This time I'm really lost :-)
How does one write a SQL FUNCTION that works in a WHERE clause ?
If fx. I like to make a function called "is_today" that take two dates
and test if they are within the same day, how can I express this in SQL
I cant make a "SELECT 1 WHERE EXTRACT( day ...", so how does one return
a boolean ?
Hopefull regards ..
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2001-08-22 14:31:09|
|Subject: Re: Boolean SQL function ? |
|Previous:||From: Bo Lorentsen||Date: 2001-08-22 12:34:58|
|Subject: Re: Subquery and where clause ?|