Re: [BUGS] BUG #3487: regular exp

2007-07-26 Thread Magnus Hagander
On Thu, Jul 26, 2007 at 05:53:54AM +, Mikhail wrote: > > The following bug has been logged online: > > Bug reference: 3487 > Logged by: Mikhail > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: windows 2003 SP2 > Description:regular

Re: [BUGS] bug with RE

2007-07-26 Thread Stephan Szabo
On Thu, 26 Jul 2007, [UTF-8] Т�^C�^Gков �^\и�^Eаил wrote: > Please, help me! > My code: > "IF char_length(substring(str from '^[a-zA-Z]*://'))=0 THEN >str:= 'http://'||str; > END IF;" > > If str= http://www.msn.com then nothing happen > (all is OK), but if str= just www.msn.com then nothing h

[BUGS] BUG #3488: exporting data

2007-07-26 Thread sreenair
The following bug has been logged online: Bug reference: 3488 Logged by: sreenair Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3 Operating system: windows xp Description:exporting data Details: Sir, While exporting data from postgres the date format is not

[BUGS] BUG #3487: regular exp

2007-07-26 Thread Mikhail
The following bug has been logged online: Bug reference: 3487 Logged by: Mikhail Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: windows 2003 SP2 Description:regular exp Details: Please, help me! My code: "IF char_length(substring(str from

[BUGS] bug with RE

2007-07-26 Thread Тучков Михаил
Please, help me! My code: "IF char_length(substring(str from '^[a-zA-Z]*://'))=0 THEN str:= 'http://'||str; END IF;" If str= http://www.msn.com then nothing happen (all is OK), but if str= just www.msn.com then nothing happen too! Why? Then I experimen with that: I change '=' to '<>' res

[BUGS] psql \COPY accepts multiple NULL AS

2007-07-26 Thread Stephen Frost
Greetings, psql seems to accept syntax which would be rejected by the server, which seems a bit odd: sfrost*=# \copy billing_data from ../BillingSamplePricerFile.csv with csv header quote as '"' null as 'abc' null as '123' ERROR: invalid input syntax for integer: "" vs.