Subject | Re: [firebird-support] Select...Into vs Assignment |
---|---|
Author | Martijn Tonies |
Post date | 2004-09-27T12:53:05Z |
> > > > In PSQL is there a difference between these 2 statements:Really ;-)
> > > >
> > > > 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?
>
> Hmm, methinks Ivan is doing a little tail-pulling here.... :-))
--
MT