On 2011-02-15, Tony Capobianco wrote:
> I'm altering datatypes in several tables from numeric to integer. In
> doing so, I get the following error:
>
> dw=# \d uniq_hits
> Table "support.uniq_hits"
>Column | Type | Modifiers
> +-+---
> sourceid | numer
Hey Gnanakumar,
You can wrap you UPDATE query into SQL function returning TABLE, e.g:
CREATE OR REPLACE FUNCTION public.update_mytable()
RETURNS TABLE(email text, column1 text, column2 text, column3 text)
LANGUAGE sql
AS $function$
UPDATE MYTABLE SET ABOOLEANCOLUMN = true FROM MYTEMPTABLE WHERE
Hey,
2011/2/16 arthur_info
>
> Hello,
>
> I've got the following function and I want to access the fields values of
> my
> record by index. The problem is that my select is retrieving each record
> line with all values and not each one of each row on my view... How can I
> solve this problem?
>
