Someone wrote in [personal profile] robbat2 2009-01-21 01:42 am (UTC)

Re: INSERT IGNORE solution

In postgres:

select set_myObject(src.f1, src.f2, src.f3)
FROM source_table src;

where set_myObject performs INSERT/IGNORE functionality and returns void (or a scalar value, say the key) and f1, f2, and f3 are fields from your select.

Postgres is much more powerful than you realize.

Post a comment in response:

This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

If you are unable to use this captcha for any reason, please contact us by email at support@dreamwidth.org