On Sat, Aug 13, 2005 at 11:19:25PM -0400, John Wells wrote: > I'm trying to write a simple function that will return a table's actual > row count on PostgreSQL 7.4. I've tried two different versions (see > below), both with the same result: > > "ERROR: syntax error at or near "select" at character 127" You're having quoting problems; see "Handling of Quotation Marks" in the "Tips for Developing in PL/pgSQL" section of the documentation: http://www.postgresql.org/docs/7.4/interactive/plpgsql-development-tips.html PostgreSQL 8.0 simplifies quoting issues by allowing an alternate style known as "dollar quoting": http://www.postgresql.org/docs/8.0/interactive/plpgsql-development-tips.html In addition, the functions you posted have "quote_ident" misspelled and they don't have RETURN statements. You might also want to create the functions as STRICT (aka RETURNS NULL ON NULL INPUT). See the CREATE FUNCTION documentation for more info: http://www.postgresql.org/docs/7.4/interactive/sql-createfunction.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
