Re: Using function like where clause - Mailing list pgsql-sql

From hubert depesz lubaczewski
Subject Re: Using function like where clause
Date
Msg-id 20070810080047.GB31829@depesz.com
Whole thread Raw
In response to Using function like where clause  (Ranieri Mazili <rmazili@wgsystems.com.br>)
List pgsql-sql
On Mon, Aug 06, 2007 at 04:44:29PM -0300, Ranieri Mazili wrote:
> 1) Can I use a function that will return a string in a where clause like
> bellow?
> 2) Can I use a function that will return a string to return the list of
> columns that I want to show like below?

not in sql. you can in pl/pgsql.

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

pgsql-sql by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Best Fit SQL query statement
Next
From: "Pablo Barrón"
Date:
Subject: Join optimization