Re: [SQL] rowtype and ecpg

2002-06-25 Thread Alla
My problem is a "rowtype" variable. I don't know how to declare a structure or anything else to pass information to the function, which input parameter has a type of "rowtype" (I have no problem retrieving any output - varchar or refcursor) Thanks Alla ---(end of bro

[SQL] unique index on function and column

2002-06-25 Thread Bruno Wolff III
Is there a simple way to do something like the following: create unique index inst_u_app on inst (lower(host), psport); It looks like you can have an index on several columns, but not several functions. ---(end of broadcast)--- TIP 2: you can get

Re: [SQL] unique index on function and column

2002-06-25 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > Is there a simple way to do something like the following: > create unique index inst_u_app on inst (lower(host), psport); > It looks like you can have an index on several columns, but not > several functions. The standard answer is to make a custom f

Re: [SQL] unique index on function and column

2002-06-25 Thread Bruno Wolff III
On Tue, Jun 25, 2002 at 14:35:16 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Bruno Wolff III <[EMAIL PROTECTED]> writes: > > Is there a simple way to do something like the following: > > create unique index inst_u_app on inst (lower(host), psport); > > > It looks like you can have an index on

Re: [SQL] what is the difference between default 0 vs default '0'

2002-06-25 Thread Christopher Kings-Lynne
Hi Beth, I wouldn't have thought there'd be any difference to you, the user. If you used 0, then that is an integer and that will be the default. If you used '0' then that is a character or string and it will automatically be cast into an integer when used as a default. Chris - Original M