On Fri, Jan 14, 2005 at 03:43:04PM -0500, Kevin B. wrote: > I'm trying to assign the row count of a query to a variable in a function > but I'm not having any luck.
Please be more specific than "not having any luck." What are you expecting to happen and what actually does happen? > Could someone tell me the syntax? I've been looking in the docs and > googling for a long time but just can't find the answer. See the "Basic Statements" and "Expressions" sections of the PL/pgSQL documentation. Either of the following should work: var := count(*) FROM T; SELECT INTO var count(*) FROM T; -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
