What version of postgresql that the update compatibility below will be
implemented?
UPDATE COMPATIBILITY
UPDATE accounts SET (contact_last_name, contact_first_name) =
(SELECT last_name, first_name FROM salesmen
WHERE salesmen.id = accounts.sales_id);
TIA,
--
Gera Mel E. Handumon
--
Hello,
Is it possible to get postgresql server ip address using sql command?
TIA,
Geramel
-
"Share your knowledge. It's a way to achieve immortality" - Dalai Lama
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To
Thanks!
On Nov 28, 2007 10:47 AM, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Nov 27, 2007, at 21:04 , Gera Mel Handumon wrote:
>
> > I encounter an error if i use NULLIF with timestamp with time zone.
> > eq. dbtime=nullif(mytime,'')
> >
>
HELLO,
I encounter an error if i use NULLIF with timestamp with time zone.
eq. dbtime=nullif(mytime,'')
i want to null the value of field DBTIME if the variable mytime=" "
DBTIME ="timestamp with time zone" datatype
error: column DBTIME is of type timestamp with time zone but expression is
of t
