Re: [SQL] Using function like where clause

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Ranieri Mazili <rmazili(at)wgsystems(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Using function like where clause
Date: 2007-08-10 08:00:47
Message-ID: 20070810080047.GB31829@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Louis-David Mitterrand 2007-08-10 08:11:29 Re: timestamp skew during 7.4 -> 8.2 upgrade
Previous Message Greg Smith 2007-08-10 07:36:28 Re: UPDATES hang every 5 minutes

Browse pgsql-sql by date

  From Date Subject
Next Message Pablo Barrón 2007-08-10 09:51:47 Join optimization
Previous Message hubert depesz lubaczewski 2007-08-10 07:59:49 Re: Best Fit SQL query statement