Re: Problem with stored procedure

Patrice OLIVER wrote:

> Hello,
>
> In this example, I use 2 tables :
> create table types (
> typnum integer primary key,
> catcode varchar(2),
> typlib varchar(35));
>
> create table uv (
> uvnum varchar(5) primary key,
> typnum integer,
> uvlib varchar(50));
>
> alter table uv
>   add constraint fk_uv_type foreign key (typnum)
>      references types (typnum)
>      on delete restrict on update restrict;
>
> I also use stored procedures :
>
> create function numtype(varchar) returns integer as '
> declare
>   codetype alias for $1;
>   coderet integer;
> begin
>   select into coderet typnum from types
>       where typcode = codetype and catcode = ''UV'';

why not -> select *typenum* into coderet  from types     where typcode = codetype and catcode = ''UV'';