Quoting Problem in PLPGSQL

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Quoting Problem in PLPGSQL
Date: 2003-11-18 08:54:38
Message-ID: 3FB9DE4E.8040201@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

i have a problem with quoting in plpgsql. I try to insert dynamically
some conditions into a select statment but for some reason it does not work.

condition := '' AND price > 500 '';

SELECT INTO tmpRec * WHERE xxxxxx || condition || ORDER BY userId ;
What is the correct way to do this ?

Thanks
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Kindness 2003-11-18 09:13:18 Re: Move a table to another schema
Previous Message 黎维 王 2003-11-18 08:43:16 how to get historical data?