Re: plpgsql function question

If you use a plpgsql function to select the row you want to validate,
it will make life much easier. Something like

...
$$
declare
my_row a_row_type;
is_ok integer;
begin
select into my_row * from a_row_type where ....
is_ok := my_a_validate(my_row);
return is_ok;
$$
...

On Apr 4, 2007, at 1:01 AM, A. Kretschmer wrote:

> Because your function expects one parameter of your new type, you have
> to CAST your data into this type:
>
>
>
> test=# select * from my_a((1, 'foo', current_date)::a);
> my_a
> ------
> 1
> (1 row)

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL