>If you're porting a bunch of code written for Oracle to Postgres,
>you'd have to run around and change every occurrence of "date" to
>"timestamp" ... unless you install orafce, in which case you can
>rely on this alias type that orafce creates. But you do then have
>two types named "date"
gzh writes:
> I did the following two tests and found that the return value of
> pg_catalog.date and oracle.date are inconsistent.
Yeah ... that's pretty much the point. Oracle uses the name "date"
for a data type that Postgres (and the SQL standard) calls a "timestamp".
That's very ancient on
> On 25/04/2023 13:34 CEST gzh wrote:
>
> >The solution is the same whether you upgrade or not: you need
> >to adjust your search_path to include the "oracle" schema,
> >or else explicitly qualify references to orafce functions.
> Thank you very much for your help.
>
> To use the to_date functions
>The solution is the same whether you upgrade or not: you need
>to adjust your search_path to include the "oracle" schema,
>or else explicitly qualify references to orafce functions.Thank you very much
>for your help.
To use the to_date functions of Orafce 3.0.1, we created the following to_date
On 4/19/23 10:02 AM, gzh wrote:
Thank you for your prompt reply.
Is there another solution if the database is not upgraded to 12.14?
Better upgrade to latest release 12.14.
The point being made was that 12.14 is the latest minor release so you
might as well upgrade to it. It will not chang
gzh writes:
> Thank you for your prompt reply.
> Is there another solution if the database is not upgraded to 12.14?
The solution is the same whether you upgrade or not: you need
to adjust your search_path to include the "oracle" schema,
or else explicitly qualify references to orafce functions
Thank you for your prompt reply.
Is there another solution if the database is not upgraded to 12.14?
>Better upgrade to latest release 12.14.
At 2023-04-19 22:51:33, "Erik Wienhold" wrote:
>> On 19/04/2023 15:24 CEST gzh wrote:
>>
>> Hi,
>>
>> I upgraded the version of PostgreSQ
> On 19/04/2023 15:24 CEST gzh wrote:
>
> Hi,
>
> I upgraded the version of PostgreSQL from 12.10 to 12.13,
Better upgrade to latest release 12.14.
> when I insert data into the t_mstr table, the to_char function in the t_mstr's
> trigger caused the following error.
>
> psql:t_mstr.sql:994: ERRO
