Re: [GENERAL] Help with case in select

2005-03-31 Thread Richard Huxton
Cristian Prieto wrote: Hello, I have the following sp, I need to return a 'Flag' if the ID of the row is in the prior select, I tryed with the following code: create or replace function sp_getadvertisers(ag integer) returns record as $main$ declare alladv record; retrec record; begin -- Primero b

[GENERAL] Help with case in select

2005-03-31 Thread Cristian Prieto
Hello, I have the following sp, I need to return a 'Flag' if the ID of the row is in the prior select, I tryed with the following code: create or replace function sp_getadvertisers(ag integer) returns record as $main$ declare alladv record; retrec record; begin -- Primero buscamos todas las campa