From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | Rod Early <REarly(at)jswcoinc(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Porting SQL Server 2000 database to PostgreSQL |
Date: | 2004-05-21 20:55:20 |
Message-ID: | 1085172920.9368.1562.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 2004-05-21 at 02:49, anony wrote:
> 3. inside the function single quotes must be escaped because your
> function is entered in as a string literal.
>
be aware that your editor might quote these for you (at least some of
the admin apps do, not sure about PgAdminIII though)
> 4. to return recordsets you must create a custom return TYPE and use a
> FOR loop with %ROWTYPE to interate thru the data.
>
this isn't always true... see
http://techdocs.postgresql.org/guides/SetReturningFunctions
And while you're there check out the section on the main page about
converting from other databases, there are a couple on $ql server. Also
take notes on your conversion and submit your own article when your done
:-)
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Carl E. McMillin | 2004-05-21 21:33:08 | Re: Am I locking more than I need to? |
Previous Message | Jim Seymour | 2004-05-21 20:51:13 | Re: Does INSERT inserts always at the end ? |