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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
