Илья Конюхов wrote:
>>For example, consider the queres:
>>
>>SELECT * FROM table1 WHERE field1=1 AND field2=1;
>>
>>SELECT * FROM table1 WHERE field2=1 AND field1=1;
>>
>>
>>These two queries are logically equivalent. But in all cases the planner
>>generates a query plan that performs field1=1 con
Hi,
I have a problem with arrays in Postgres. I want to create a really
large array, lets say 3 billion characters long.
As far I could read from the documentation - this should be possible.
But my question is, is there a kind of index on the array.
Lets say, I want to get element 2,675,345,328.
Hello,
I have a table that has an attribute 'identifier', declared as integer
and an attribute 'plane_coord' defined as 'point':
Table "reference.coord_test"
Column| Type | Modifiers
-+-+---
node_name | integer |
plane_coord | point |
I would like to fi
Hi,
I am using PostgreSQL 7.4 and was trying to log the time each part of a
function needs. I found a pretty helpful bit of code in the documentation:
http://www.postgresql.org/docs/7.4/static/plpgsql-expressions.html
I used the following function, called inside the another function:
CREATE or re
[EMAIL PROTECTED] schrieb:
Hi,
i use postgresql as my database. does anyone know the designer tool that
can connect to postgeSQL ??? meaning to say the tools
can handle design task like create table , etc . appreciate if u can
give the specific URL. thanks in advance.
Try this one:
http://www
Hi,
I have an application where users can enter the date via a web interface.
Recently I upgrated my PostgreSQL version from 7.3 to 7.4.1.
On 7.3 I run several tests about the format of the date and found,
that Postgres accepts almost everything. Today I found out, that 7.4.1
only accepts dates
Hi,
I would like to insert into a table values from a table and user defined
ones. Here is the example:
I found this statement to insert values from another table:
INSERT INTO test_table (cust_id, cust_name) SELECT id, name from CUSTOMER;
But the test_table has another column, which should hav
