Reg: SQL Query for Postgres 8.4.3

From: Srinivas Naik <naik(dot)srinu(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Reg: SQL Query for Postgres 8.4.3
Date: 2010-05-04 06:47:37
Message-ID: g2k2e482c091005032347r5faebcc9ma1a62241000927c6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2010-05-04 07:36:14 Re: max_standby_delay considered harmful
Previous Message Pavel Stehule 2010-05-04 05:36:19 Re: what is good solution for support NULL inside string_to_array function?