On Tue, Dec 16, 2008 at 12:16 PM, Tom Lane wrote:
> it's been like
> that for so long that I'm worried about how much user code we'll break
> if we do.
>
code making something like that is actually broken, what a "fix" here
will do is making that obvious...
--
Atentamente,
Jaime Casanova
Soport
Alvaro Herrera writes:
> Asko Oja escribió:
>> I was quite amazed to find that this piece of code actually works while
>> reviewing code.
>> I would prefer if it gave an error :)
> Yeah, me too.
As the plpgsql docs say, "The INTO clause can appear almost anywhere in
the SQL command". You can wr
Asko Oja escribió:
> I was quite amazed to find that this piece of code actually works while
> reviewing code.
> I would prefer if it gave an error :)
Yeah, me too. The functions posted by Josh Drake yesterday about
constraint exclusion had something like
select * from into temp table ...;
(temp
I was quite amazed to find that this piece of code actually works while
reviewing code.
I would prefer if it gave an error :)
test=# create or replace function test(i_input text) returns text as
$$
declare
result text;
begin
SELECT
CASE
WHEN lower(i_input) ~ '^[a-z]' THEN '