[SQL] FIND_IN_SET

2009-12-11 Thread Michael Eshom
I am on the marketing team for a popular forum system, and am also the primary PostgreSQL tester/bugfixer. Currently our forum system treats MySQL's FIND_IN_SET() as a boolean (eg whether or not the specified value was found in the given set), which is fine since MySQL will treat any integer gr

[SQL] Adding NOT NULL columns in PostgreSQL 7.4?

2007-08-07 Thread Michael Eshom
in PostgreSQL 7.3, so I can't figure out why it's still saying it's not implemented. -- Michael Eshom Christian Oldies Fan Cincinnati, Ohio

[SQL] Unable to create function which takes no arguments

2008-06-09 Thread Michael Eshom
LECT current_timestamp()::int4 AS result; ' LANGUAGE SQL; The documentation indicates that the arguments are optional, and even shows an example of a function with no arguments. How can I create this function? -- Michael Eshom Christian Oldies Fan Cincinnati, Ohio