[SQL] sintax error

2010-02-19 Thread iuri de araujo sampaio
Hi there, i have got the followed error in the pgsql function bellow. Log messages point to: ERROR: syntax error at end of input LINE 1: SELECT ^ QUERY: SELECT CONTEXT: SQL statement in PL/PgSQL function "cms_permission__revoke_permission" near line 67 *

[SQL] date format

2008-01-24 Thread iuri de araujo sampaio
hi, how to change the default format for type date? I have created a field on a table: ## create table tbl_inventory ( item_id integer constraint c_pk primary key, I. purchase_date date, II. fabrication_date date, III. expiration_date date ); ## the er