Postgres Pro
Downloads
Home   >   mailing lists

Re: Correct Insert SQL syntax? - Mailing list pgsql-sql

From Bart Degryse
Subject Re: Correct Insert SQL syntax?
Date
Msg-id 48C0F493.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Re: Correct Insert SQL syntax?  ("Ruben Gouveia" <rubes7202@gmail.com>)
List pgsql-sql
Tree view
You might wanna check out the PostgreSQL manual.
There's definitely an answer in it to all your questions.
Especially chapter 38 on migrating from Oracle to PostgreSQL might be helpful.
http://www.postgresql.org/docs/8.3/interactive/plpgsql-porting.html

>>> "Ruben Gouveia" <rubes7202@gmail.com> 2008-09-05 0:56 >>>
Thanks Yuri!

On Thu, Sep 4, 2008 at 3:49 PM, Yura Gal <yuragal@gmail.com> wrote:
There is no internal dual table in PG unlike Ora:) If you need to
invoke non-set-returning function simply execute:

SELECT my_func(p1, p2...);

--
Best regards, Yuri.

pgsql-sql by date:

Previous
From: "Ruben Gouveia"
Date:
Subject: Re: Correct Insert SQL syntax?
Next
From: Lennin Caro
Date:
Subject: Re: Correct Insert SQL syntax?