| From: | Radek Kanovsky <radekk(at)uh(dot)cz> |
|---|---|
| To: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | create function(date,date,date,...) |
| Date: | 1999-09-25 17:51:01 |
| Message-ID: | Pine.LNX.3.96.990925193818.18476s-100000@rk.uh.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Hi,
i am trying to declare function that gets six date arguments
and returns some status according actual date. It looks like
this:
CREATE FUNCTION datum_ok(DATE,DATE,DATE,DATE,DATE,DATE) RETURNS TEXT AS '
DECLARE
tests ALIAS FOR $1 ;
teste ALIAS FOR $2 ;
payments ALIAS FOR $3 ;
paymente ALIAS FOR $4 ;
interrupts ALIAS FOR $5 ;
interrupte ALIAS FOR $6 ;
today DATE ;
BEGIN
today := now()::date ;
.....
It happens that when some argument is NULL, than all argument get NULL.
It works correctly only when all arguments are not NULL.
SELECT
login,
datum_ok(
test_start, test_end,
payment_start, payment_end,
interrupt_start, interrupt_end )
FROM service ;
How can I mix NULL and DATE values in arguments?
Thanks
Radek Kanovsky, rk(at)uh(dot)cz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Weinberg | 1999-09-26 02:13:17 | Memory exhausted in AllocSetAlloc() |
| Previous Message | Peter Mount | 1999-09-25 10:06:41 | Re: [GENERAL] Is it possible run pgsql in Windows 95 ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-09-25 22:46:50 | Re: [SQL] create function(date,date,date,...) |
| Previous Message | Radek Kanovsky | 1999-09-25 15:15:11 | 11128.1 != 11128.1 |