Re: very basic SQL question - Mailing list pgsql-general

From Dan Kortschak
Subject Re: very basic SQL question
Date
Msg-id 1290544837.3857.2.camel@sol
Whole thread Raw
In response to Re: very basic SQL question  (Matthieu Huin <matthieu.huin@wallix.com>)
List 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



pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Passing a String with special character as an input
Next
From: Brar Piening
Date:
Subject: Re: "could not accept SSPI security context"