On Mon, 28 Mar 2005 11:57:10 -0500, Iulian Popescu <[EMAIL PROTECTED]> wrote: > That doesn't work either - I get the same error. > From the documentation: > > This routine returns a string which is the value of its argument suitable > for inclusion into another SQL statement. Strings are surrounded by > single-quotes with escapes on interior quotes as needed. BLOBs are encoded > as hexadecimal literals. The current implementation of VACUUM uses this > function. The function is also useful when writing triggers to implement > undo/redo functionality. > > Therefore I was expecting that something like: > > SELECT quote(AA'AA) > > would work in the sense that the actual SQL statement executed will be: > > SELECT 'AA''AA' > > but it doesn't seem to.
I suspect it was intended to be used like this: select quote(columname) from table; Chris -- | Christopher Petrilli | [EMAIL PROTECTED]
