[BUGS] sql function returning composite type

2004-09-21 Thread Ivan
Hello, Suppose we have sql function which returns composite type. When such function's last select statement doesn't return any row error occurs - ERROR: function returning row cannot return null value. But if we use similar function that returns set of same type error not occurs. Example:

Re: [BUGS] sql function returning composite type

2004-09-21 Thread Tom Lane
Ivan <[EMAIL PROTECTED]> writes: > Suppose we have sql function which returns composite type. > When such function's last select statement doesn't return any row > error occurs - > ERROR: function returning row cannot return null value. Works for me (tested in 7.4.5 and CVS tip).

Re: [BUGS] sql function returning composite type

2004-09-21 Thread Ivan
Hello Tom, Tuesday, September 21, 2004, 6:17:37 PM, you wrote: TL> Ivan <[EMAIL PROTECTED]> writes: >> Suppose we have sql function which returns composite type. >> When such function's last select statement doesn't return any row >> error occurs - >> ERROR: function returning row cannot return

Re: [BUGS] sql function returning composite type

2004-09-21 Thread Tom Lane
Ivan <[EMAIL PROTECTED]> writes: > Error occurs when do > select * from "test"('secon') Ah. I was trying "select test('foo')" which does work. Will look at it. regards, tom lane ---(end of broadcast)--- TIP 6: Have you sea

Re: [BUGS] Money type not gone?

2004-09-21 Thread Josh Berkus
Karel, Andreas, > > My idea is special internal API that will usable for new datetypes > > programming if type is defined as "numeric + symbol", for example things > > like speed, weight, currency.. etc. > > A type consisting of value and unit probably makes pgsql even more first > choice for tech

Re: [BUGS] Money type not gone?

2004-09-21 Thread Andreas Pflug
Josh Berkus wrote: The difference with currency would be the lack of a fixed conversion for different units.For example, you can: You're mixing up quite a lot of stuff here. 10m == 1000cm This is just what I considered forbidden to be included in that "unit-ed type" in my previous mail. c = c

[BUGS] BUG #1261: CREATE DATABASE OWNER not propagating to child objects?

2004-09-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1261 Logged by: Sean Chittenden Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: OS-X, FreeBSD Description:CREATE DATABASE OWNER not propagating to child objects? Details: H

[BUGS] BUG #1262: Jimminy Cricket

2004-09-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1262 Logged by: Nadia Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.7 Operating system: Windows XP Description:Jimminy Cricket Details: This bug looks cute and convincing, but BEWARE. Despite h

[BUGS] BUG #1263: Jimminy Cricket

2004-09-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1263 Logged by: Nadia Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.7 Operating system: Windows XP Description:Jimminy Cricket Details: This bug looks cute and convincing, but BEWARE. Despite h

[BUGS] BUG #1264: Jimminy Cricket

2004-09-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1264 Logged by: Nadia Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.7 Operating system: Windows XP Description:Jimminy Cricket Details: This bug looks cute and convincing, but BEWARE. Despite h