Subject | Re: [firebird-support] Select...Into vs Assignment |
---|---|
Author | Helen Borrie |
Post date | 2004-09-27T12:05:22Z |
At 01:19 PM 27/09/2004 +0200, you wrote:
./heLen
> > > In PSQL is there a difference between these 2 statements:Hmm, methinks Ivan is doing a little tail-pulling here.... :-))
> > >
> > > select CREATEGUID() from RDB$DATABASE into :USERID;
> >
> > Or you can use this as well:
> >
> > select CREATEGUID() from rdb$database left join rdb$relations on
> > rdb$database.rdb$relation_id=rdb$relations.rdb$relation_id left join
>rdb$procedures on
> > rdb$relations.rdb$relation_id=rdb$procedures.rdb$procedure_id into
>:USERID;
>
>Hmmm... this looks overly complicated to me. Did you test it?
./heLen