Home > mailing lists

Reg: SQL Query for Postgres 8.4.3 - Mailing list pgsql-hackers

From	Srinivas Naik
Subject	Reg: SQL Query for Postgres 8.4.3
Date	May 4, 2010 06:47:46
Msg-id	g2k2e482c091005032347r5faebcc9ma1a62241000927c6@mail.gmail.com Whole thread Raw
Responses	Re: Reg: SQL Query for Postgres 8.4.3
List	pgsql-hackers

Hi,

Can any one tell me whats the effect of the below Query

SELECT substring(B'1111000000000001' from 5 for -2);

SELECT substring(B'1111000000000001' from 4 for -3);

its observed that there's an Error "invalid memory alloc request size 4244635647"

What will actually happen to the Postgresql database.

I am using Postgresql 8.4.3 on Ubuntu 8.04

Thanks in Advance

Regards,

Srinivas Naik

From: "Ioseph Kim"
Date: 04 May 2010, 05:59:20
Subject: Re: CP949 for EUC-KR?

From: Simon Riggs
Date: 04 May 2010, 08:14:41
Subject: Pause/Resume feature for Hot Standby