Re: [SQL] COUNT(*) to find records which have a certain number of

2004-09-26 Thread Martin Knipper
Am 20.09.2004 18:19 schrieb T E Schmitz: > I figured it eventually. (The only thing I don't know is where to put > the ORDER BY.) > > >>I want to select only those BRAND/MODEL combinations, where the MODEL >>has more than one TYPE, but only where one of those has TYPE_NAME='xyz'. >>I am not int

Re: [SQL] plpgsql - accessing fields of record type

2004-09-26 Thread Michael Fuhr
On Sun, Sep 26, 2004 at 06:15:57PM +0200, Sz?lka Tam?s wrote: > I have a table with field named "XY_1", "XY_2", ... "XY_255". > I want to access the values in the table from a plpgsql function somehow > in a loop with the iterative variable. Can I address the appropriate > ''XY_'' || loopvaria

[SQL] plpgsql - accessing fields of record type

2004-09-26 Thread Szálka Tamás
Hi! I'd like to ask whether it is possible to access fields of record type variable in plpgsql in the following way: I have a table with field named "XY_1", "XY_2", ... "XY_255". I want to access the values in the table from a plpgsql function somehow in a loop with the iterative variable. Can I