[EMAIL PROTECTED] writes:
> select
> *
> from
> test1 left join test2 on (test1.test1_id = test2.test1_id)
> where
> test1.test1_id = test2.test1_id;
Hm. I think what is happening is that the planner is (mistakenly)
deciding that the where-clause and on-clause are equivalent, and
so dropping
Elielson Fontanezi wrote:
> GRANT ALL on "recursos_materiais" to "user_fomacao_des"; --< Here is the
> point in question
[...snip...]
> REVOKE ALL on "recursos_materiais" from PUBLIC;
> GRANT ALL on "recursos_materiais" to "131"; --< What is it?
>
> Is that a bug?
It looks like someone dropped u
Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes:
> SPI, and I have trap again - I can't translate datetime column, which
> pass to my procedure. I must convert it to UNIX 1970-seconds counter for
> my internal needs, but I havn't found _any_ PG_GETARG_* function in fmgr.h,
> which can read time typ
karsten merkle ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
null resulting from left join corrupts select
Long Description
Version:
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
Error:
equal in where clause fa
Hi Every Body!
I would like to know if someone has seen the behavior described
below.
By considering a DLL like this:
CREATE TABLE "recursos_materiais" (
"nr_rec_mat" smallint NOT NULL,
"dc_rec_mat" character varying(100),
"in_situacao_rec_mat" character(1),
Joe Conway wrote:
> Ruslan A Dautkhanov wrote:
> > Btw, how I can convert TEXT field to a CString one? I had tried to use
> > char *cnum = PG_GETARG_CSTRING(0) instead of
> > text tnum = PG_GETARG_NAME(0), but it's not worked properly. Is any function
> > to convert text object to a null-t
