to the junk filter that is not present in the schema of the table
, that i will generate on the fly ??
If yes, how can i do that ?? Thanks in advance.
Regards,
Sri Harsha
Hi,
In PostgreSQL , does the order in which the criteria is given matter ??
For example
Query 1 : Select * from TABLE where a > 5 and b < 10;
Query 2 : Select * from TABLE where b <10 and a > 5;
Are query 1 and query 2 the same in PostgreSQL or different ?? If its
different , WHY ??
Its not an OpExpr . It is a VAR , got it from "reltargetlist" in base
relation ( RelOptInfo) . Can you shed some light on where the conversion
from 141 to "original" attribute number takes place ??
Regards,
Harsha
On Fri, Apr 29, 2016 at 10:03 AM, Tom Lane <t...@sss.p
Hi,
Assume the following query ,
(SELECT a * 1 , b FROM TABLE_1) UNION ALL (SELECT a *1 , b FROM TABLE_2);
In this query , attribute number of the VARs are 141 and 2 respectively !!
What is the reason for this ??
I am trying to implement a FDW , so i need attribute numbers to fetch the
Hi,
Is it possible to use threads in Postgresql ?? I am using threads in my
foreign data wrapper and i get the following error when i use the threads .
*ERROR: stack depth limit exceeded*
*HINT: Increase the configuration parameter "max_stack_depth" (currently
2048kB), after ensuring the
Hello,
I am using a foreign data wrapper where i get a portion of my data
pre-loaded , i.e I get a set of rows before hand . So now i want to run
multiple update queries on this loaded data , write the changes to file ,
load the next set and continue with updates again.
How should i