I recieve this error when executing the following function:
select lookup_journal_entries(to_date('20030125','MMDD'),
to_date('20030125','MMDD'));
Here is the function itself:
create function lookup_journal_entries(date,date) returns setof journal as '
selec
I figured out the issue, DH stupid mistake
select entry_id, entry_description from
lookup_journal_entries(to_date('20030125','MMDD'),
to_date('20030125','MMDD'));
> I recieve this error when executing the following function:
>
> select lookup_journal_entries(to_
On Friday 24 January 2003 19:17, Josh Berkus wrote:
> The MONEY type is depreciated, and should have been removed from the
> Postgres source but was missed as an oversight. Use NUMERIC instead.
Note that not all of us agree. I had to change all of our fields from MONEY
to NUMERIC recently beca
On Sun, 26 Jan 2003, D'Arcy J.M. Cain wrote:
> This year, my team is planning on improving the MONEY type. Of course, we can
> always make it a user defined type if PostgreSQL doesn't want it. We will at
> least put it into contrib. However, if people think that it is useful and
> want to leave
On Sun, 2003-01-26 at 13:53, D'Arcy J.M. Cain wrote:
> This year, my team is planning on improving the MONEY type. Of course, we can
> always make it a user defined type if PostgreSQL doesn't want it. We will at
> least put it into contrib. However, if people think that it is useful and
> wa
> > Yes! cron
> >
> Here is the basic problem w/ using CRON in an accounting situation.
>
> I can't be sure that cron will always be up when the DB is up,
> so lets say crond goes down for some random reason (User, System
error,
> Etc..)
>
> And outside adjustment is made to lets say the equipmen
Actually, the new 7.3.1 error message is:
if (!S_ISREG(buf.st_mode) || (buf.st_mode & 0077) ||
buf.st_uid != getuid())
{
postmaster_error("bad permissions on private key file (%s)\n"
"File must be owned by the proper user and must have no permissions for\n"
Hi shreedhar :
--- shreedhar <[EMAIL PROTECTED]> wrote:
> Can any body tell that how sub queries and joins
> differs funcationally.
> Because sub queries taking lot of time than joins.
>
The following could be the probable reasons:
a) Your are using correlated queries - Correlated
queries
