Hello
2013/3/13 Paolo Grifa :
> Hi all,
> I am quite new in postgres, having experience with Oracle.
> I was trying to migrate some very simple applications from Oracle and found
> out that some functions like TRUNC() are only available via an addon called
> "orafce". The problem is that it seems
Hi Paolo,
we have recently migrated orafce to github
(https://github.com/orafce/orafce) and are in the middle of the process
for migrating the mailing list to Google Groups.
You are better off asking here:
https://groups.google.com/forum/?fromgroups#!forum/orafce-general
Thanks,
Gabrie
Hi all,
I am quite new in postgres, having experience with Oracle.
I was trying to migrate some very simple applications from Oracle and found
out that some functions like TRUNC() are only available via an addon called
"orafce". The problem is that it seems only available for Postgres 9.1,
while we
Hello
2012/1/13 bj77 :
> Hi,
>
> OS: SUSE LINUX
>
> I am writing a logfile (batch process) with the ORAFCE utilities of
> UTL_FILE.
> I recently observed that the logfile is not refreshed after every new entry
> written. It appears to me that the every 4096 bytes of data are written at
> the same
Hi,
OS: SUSE LINUX
I am writing a logfile (batch process) with the ORAFCE utilities of
UTL_FILE.
I recently observed that the logfile is not refreshed after every new entry
written. It appears to me that the every 4096 bytes of data are written at
the same time.
Can anyone explain me this please
2010/2/10 Yeb Havinga :
> Pavel Stehule wrote:
>>>
>>> What about adding something like operator ||| in the orafce package for
>>> concat?
>>>
>>
>> no, it could be confusing and it isn't enough, because it isn't only
>> || or concat problem. On Oracle empty string is equal to NULL and NULL
>> is e
Pavel Stehule wrote:
What about adding something like operator ||| in the orafce package for
concat?
no, it could be confusing and it isn't enough, because it isn't only
|| or concat problem. On Oracle empty string is equal to NULL and NULL
is equal to empty string.
example: '' is null, l
2010/2/10 Yeb Havinga :
> Hello list,
>
> The Orafce compatibility package doesn't seem to have operators defined
> (looked in the sql load file). The function I'm specifically interested in,
> is Oracle's concatenation that regards a NULL as the empty string and hence
> returns 'the other value'.
Hello list,
The Orafce compatibility package doesn't seem to have operators defined
(looked in the sql load file). The function I'm specifically interested
in, is Oracle's concatenation that regards a NULL as the empty string
and hence returns 'the other value'. This in contrast with Pg's || t
