Re: [BUGS] BUG #2334: WHERE IN (SUBSELECT) fails when column is null

2006-03-21 Thread Marinos Yannikos
Stephan Szabo schrieb: AFAICS, our behavior follows SQL. a NOT IN b is NOT(a IN b) IN is defined in terms of = ANY. a =ANY (b) is basically (by my reading of 8.8 anyway): True if a = bi for some bi in b False if b is empty or a <> bi for all bi in b Unknown otherwise Since a <> NULL returns u

Re: [BUGS] BUG #2343: Silent installers fails

2006-03-21 Thread Magnus Hagander
> Bug reference: 2343 > Logged by: Anton > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.2 > Operating system: Windows XP > Description:Silent installers fails > Details: > > Hi All, > > When the installer creates the user account, I get the > following

[BUGS] BUG #2345: odbc driver doesn't work

2006-03-21 Thread Kashin Oleg
The following bug has been logged online: Bug reference: 2345 Logged by: Kashin Oleg Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: FreeBSD Description:odbc driver doesn't work Details: Hello! I've the trouble. I'd installed unixodbc 2.

[BUGS] BUG #2343: Silent installers fails

2006-03-21 Thread Anton
The following bug has been logged online: Bug reference: 2343 Logged by: Anton Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Windows XP Description:Silent installers fails Details: Hi All, When the installer creates the user account,

[BUGS] BUG #2344: Silent installers fails

2006-03-21 Thread Anton
The following bug has been logged online: Bug reference: 2344 Logged by: Anton Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Windows XP Description:Silent installers fails Details: Hi All, When the installer creates the user account,

Re: [BUGS] No length checking for "name" input

2006-03-21 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > There appears to be no length checking for data types of "name". What there is is automatic truncation to the maximum allowed length (63 by default). This is the same behavior specified for identifiers in the SQL standard, and it's also the same behav

[BUGS] No length checking for "name" input

2006-03-21 Thread Donald Fraser
PostgreSQL versions: 7.4.x and 8.0.x (I don't have a 8.1.x installation to test against)   There appears to be no length checking for data types of "name".   For example: template1=# SELECT length('rpt_cisx_total_principal_amount_of_security_type_between_dates('::name) AS name_len; name_len