🚀 go-pugleaf

U�ytkownik "Darius Evseicikas" <dariuse@progmera.lt> napisa� w wiadomo�ci 
news:45f12ed6@newsgroups.borland.com...
> Hello,
>
> I need to make the procedure
>
> CREATE PROCEDURE ANGELE_4 (
>    NUO DATE,
>    IKI DATE)
> RETURNS (
>    OBJEKTAS VARCHAR (100),
>    METAI INTEGER,
>    MENUO INTEGER,
>    MODELIU_SK INTEGER)
> AS
> BEGIN
>     for select objektai.pavad, extract (year from pard2.dok_data), extract 
> (month from pard2.dok_data)
>         from pard2
>         left join kontrahentai objektai on (kontrahentai.id = 
> pard2.obj_id)
>         where (pard2.dok_data between :NUO and :IKI) and objektai.tipas = 
> 5
>         group by 1,2,3
>         into :objektas, :metai, :menuo
>     do begin
>           suspend;
>        end
> END
>
> But I can't to group selected fields, how I can to write the group section 
> ?
>
> -- 
> Pagarbiai
> Darius Evseicikas
> ==================
> UAB "PROGMERA"
> Maironio g. 3, LT-60149, Raseiniai
> tel./faks. +370 428 70329
> mob. +370 699 97390
> ICQ 297832308
>
> Informacija �iame prane�ime gali b�ti konfidenciali. Ji skirta tik 
> asmeniui, kuriam yra adresuota. Jei J�s nesate tas asmuo (arba atsakingas 
> u� �io prane�imo pristatym� tam asmeniui), J�s negalite skaityti, 
> kopijuoti ar bet kaip platinti �io prane�imo viso ar i� dalies ir skleisti 
> jame esan�ios informacijos. Jei �� prane�im� gavote per klaid�, pra�ome 
> informuoti apie tai siunt�j� ir i�kart i�trinti visas �io prane�imo 
> kopijas i� J�s� sistemos.

why you need group by if you not use any agregate function?
Use order by in this case if you reale not need group by.

Karol Bieniaszewski