Re: Correct Insert SQL syntax?

From: "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>
To: "Ruben Gouveia" <rubes7202(at)gmail(dot)com>, "Yura Gal" <yuragal(at)gmail(dot)com>
Cc: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Correct Insert SQL syntax?
Date: 2008-09-05 06:57:55
Message-ID: 48C0F493.A3DD.0030.0@indicator.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

You might wanna check out the PostgreSQL manual.
http://www.postgresql.org/docs/
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(at)gmail(dot)com> 2008-09-05 0:56 >>>
Thanks Yuri!

On Thu, Sep 4, 2008 at 3:49 PM, Yura Gal <yuragal(at)gmail(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lennin Caro 2008-09-05 16:11:58 Re: Correct Insert SQL syntax?
Previous Message Ruben Gouveia 2008-09-04 22:56:13 Re: Correct Insert SQL syntax?