Re: quote in string - Mailing list pgsql-general

From Alban Hertroys
Subject Re: quote in string
Date
Msg-id 673C1BBA-AC6A-48F9-B3F7-13423F88904C@solfertje.student.utwente.nl
Whole thread Raw
In response to quote in string  (finecur <finecur@yahoo.com>)
List pgsql-general
On May 21, 2008, at 7:36 PM, finecur wrote:
> select * from my_flexible_sql_function('select * from employee where
> dep ='Eng'    ')

You need to escape that string like 'select * from employee where dep
=''Eng'' '

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,483665eb927662006790369!



pgsql-general by date:

Previous
From: Sushant Sinha
Date:
Subject: Re: Fragments in tsearch2 headline
Next
From: "Konsta Tiihonen"
Date:
Subject: F-Secure and PostgreSQL