Hi,
I have to port an application from MS SQL7 to Postgresql (7.4).
When I have a column with a datetime on MS SQL7 the following is possible:
INSERT INTO mytable (mydate) values ('');
In this case MSSQL will insert '01.01.1900' as the date.
When I do the same on Postgresql it says:
"invalid i
Hi,
> > Not directly. I suppose you could create a view that converted the
> > value to the right date on insert.
> I think a trigger might make more sense.
That was a very good idea! I tought it would solve my problem. Unfortunately
it didn't: I still get the "invalid syntax" error (I ensured th
Hi,
I have a database with operators and functions in plpgsql.
To update the data to the latest version I would like to drop all operators.
There might be some, that I don't know. I don't have access to the database,
but have to write a script, that will update the data.
Is there any way to drop
