| From: | Dan Kortschak <dan(dot)kortschak(at)adelaide(dot)edu(dot)au> |
|---|---|
| To: | Matthieu Huin <matthieu(dot)huin(at)wallix(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: very basic SQL question |
| Date: | 2010-11-23 20:40:37 |
| Message-ID: | 1290544837.3857.2.camel@sol |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks for that - yes very helpful. Good to know what is possible.
Dan
On Tue, 2010-11-23 at 10:27 +0100, Matthieu Huin wrote:
> A similar question was discussed here about 3 weeks ago :
> http://archives.postgresql.org/pgsql-general/2010-11/msg00110.php
>
> The "UPSERT" facility not being implemented yet, I don't think it is
> possible to do much better than what you came up with.
>
> Assuming the column(s) holding the distinctive sequence data are defined
> with the UNIQUE constraint, you could adapt the example function given
> in the link to the documentation in the previous thread to achieve what
> you want.
>
> Hope this helps,
>
> Matthieu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brar Piening | 2010-11-23 21:05:10 | Re: "could not accept SSPI security context" |
| Previous Message | akp geek | 2010-11-23 20:34:39 | Passing a String with special character as an input |