[SQL] date format

2000-05-28 Thread Carolyn Wong
Hi All I'm using V6.5. I need to use the dd/mm/yy format, but the database seems to interpret it as mm/dd/yy, unless the digig >12, then the date format is interpreted as dd/mm/yy. Are there any setting required?

Re: [SQL] plpgsql variable substitution problem ...

2000-05-28 Thread Tom Lane
Greg Wickham <[EMAIL PROTECTED]> writes: > 000528.19:45:45.725 [9553] query: SELECT max( $1 ) FROM $2 There is no facility in plpgsql for run-time specification of a table name, and probably never will be for the general case. It's possible that it could be made to work for selection of a par

[SQL] plpgsql variable substitution problem ...

2000-05-28 Thread Greg Wickham
[Hopefully the correct list this time :)] Howdy. Creating a function to access different tables depending on the arguments. However, am having excessive problems. Current code is as follows: CREATE FUNCTION access(varchar,varchar) RETURNS INT4 AS ' DECLARE lcl_field ALIAS FOR $1;