From: | Hannu Krosing <hannu(at)trust(dot)ee> |
---|---|
To: | Vadim Mikheev <vadim(at)krs(dot)ru> |
Cc: | pgsql-interfaces(at)postgreSQL(dot)org, hackers(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] Re: [HACKERS] changes in 6.4 |
Date: | 1998-07-16 10:56:40 |
Message-ID: | 35ADDC68.F13FACB0@trust.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-interfaces |
Vadim Mikheev wrote:
>
> Hannu Krosing wrote:
> >
> > but functions still dont work:
> >
> > hannu=> create table test1 (a text, b text,
> > hannu-> check (trim(a) <> '' or trim(b) <> ''));
> > ERROR: parser: parse error at or near "trim"
>
> TRIM is keyword, not a function...
> We have to copy some lines in gram.y
Wow! is this standard ?
I found the function trim by doing 'select oprname from pg_oper'
and tested it as follows:
hannu=> select trim(' x ');
btrim
-----
x
(1 row)
why is the column called btrim ?
some rewrite magic in parser ?
If it must stay a keyword, then perhaps we should remove the proc ?
> Real functions are working...
yep! Thanks:
create table test2(a text,b text, check (btrim(a) <> '' or btrim(b) <>
''));
does work ;)
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-07-16 13:36:01 | Re: [INTERFACES] Re: [HACKERS] changes in 6.4 |
Previous Message | Aleksey Dashevsky | 1998-07-16 10:35:30 | Re: [INTERFACES] Re: [HACKERS] changes in 6.4 |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-07-16 13:36:01 | Re: [INTERFACES] Re: [HACKERS] changes in 6.4 |
Previous Message | Aleksey Dashevsky | 1998-07-16 10:35:30 | Re: [INTERFACES] Re: [HACKERS] changes in 6.4 |
From | Date | Subject | |
---|---|---|---|
Next Message | Telephone VdB Foods Ltd | 1998-07-16 12:14:51 | A working combination .... |
Previous Message | Aleksey Dashevsky | 1998-07-16 10:35:30 | Re: [INTERFACES] Re: [HACKERS] changes in 6.4 |