Re: quote in string

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: finecur <finecur(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: quote in string
Date: 2008-05-23 06:36:26
Message-ID: 673C1BBA-AC6A-48F9-B3F7-13423F88904C@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Konsta Tiihonen 2008-05-23 07:36:17 F-Secure and PostgreSQL
Previous Message Sushant Sinha 2008-05-23 05:10:27 Re: Fragments in tsearch2 headline