On Thursday 19 March 2009 5:25:03 pm jc_mich wrote: > Hi all > > I'm new in PL/PGSQL developing, I'm trying to initialize a variable from a > SQL query, this query counts some rows, I've made the next code, but it > doesn't work. > > CREATE FUNCTION schema.myFunction() RETURNS BOOLEAN AS $$ > DECLARE > counter RECORD; > BEGIN > SELECT * INTO STRICT counter FROM (SELECT COUNT (DISTINCT (rows)) FROM > schema.table); > > I'm pretty annoyed, because I've found some examples that use this kind of > variable initialization. > > Is there someone who know what I did wrong? > > Thanks! > > -- > View this message in context: > http://www.nabble.com/Initializing-variables-from-SQL-query-tp22612191p2261 >2191.html Sent from the PostgreSQL - general mailing list archive at > Nabble.com. What is the error you are getting? -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
