Postgres Pro
Downloads
Home   >   mailing lists

Quoting Problem in PLPGSQL - Mailing list pgsql-general

From Alex
Subject Quoting Problem in PLPGSQL
Date
Msg-id 3FB9DE4E.8040201@meerkatsoft.com
Whole thread Raw
Responses Re: Quoting Problem in PLPGSQL  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: 黎维 王
Date:
Subject: how to get historical data?
Next
From: Lee Kindness
Date:
Subject: Re: Move a table to another schema