John R Pierce, 05.10.2012 08:34:
On 10/04/12 11:21 PM, Thomas Kellerer wrote:
You are also moving to a Java version that is soon to be de-supported.
Java is supported?
Found the link as well:
http://www.oracle.com/technetwork/java/javase/eol-135779.html
Quote: "After February 2013, O
Evan D. Hoffman wrote on 11.10.2012 20:54:
Is there any way to disable the guessing of missing columns in a
group-by (the feature added in 9.1)?
Because we have both 9.0 and 9.1 running, and a query that succeeds
under 9.1 was failing under 9.0. Can I assume the answer then is
"no"?
If you
Jayadevan M, 25.10.2012 05:15:
There are tools which generate data, but most of them seem to
generate junk data.
Have a look a Benerator. It can create quite reasonable test data (e.g. valid addresses,
"real" looking names and so on).
It has a bit steep learning curve, but I'm quite happy wit
Hello,
I'm trying to import a text file into a table using the COPY command.
The text file contains four columns: id, col_1, col_2, col_3 (in that order).
My target table only has id and col_1.
From the documentation I assumed that the following statement
copy foo (id, col_1)
from 'foo.txt
Craig Ringer wrote on 11.11.2012 11:23:
It seems like you want to be able to say something like this (imaginary)
syntax:
\copy test_copy (id, col1) FROM 'test.csv' CSV COLUMNS(1,2,IGNORE)
or some similar way to provide a column mapping from the CSV columns to
the output of the COPY command.
Vishalakshi Navaneethakrishnan, 15.11.2012 12:11:
Hi all,
Can we create composite index for one text column and integer column?
Yes of course. What happened when you tried?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:/
Tobias Meyer, 28.11.2012 10:02:
Hello list,
we have a database with several tables containing blobs (as oid),
that reference large objects in pg_largeobject.
It is my understanding, that the large objects will not be deleted if
a row containing the oid is deleted – you have to do that yourself
Hi,
I just noticed the following statement in the CREATE VIEW documentation (9.2
and 9.1):
Currently, views are read only: the system will not allow an insert,
update, or delete on a view. You can get the effect of an updatable view by
creating rules that rewrite inserts, etc. on th
Kevin Grittner, 29.11.2012 15:27:
Ray Stell wrote:
http://www.youtube.com/watch?v=1PoFIohBSM4
I really don't want to get into bashing another product or starting
a flame war, but I'm curious -- is everything shown there really
the behavior of the MySQL database itself?
Yes, it is.
It *is*
I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application
are failing when cleaning up my test database.
I am using the statement:
drop owned by wbjunit cascade;
at the end of a test suite to get rid of everything that was created during the
tests.
Now since the upgrade
Thomas Kellerer wrote on 09.12.2012 11:36:
I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application
are failing when cleaning up my test database.
I am using the statement:
drop owned by wbjunit cascade;
at the end of a test suite to get rid of everything that was
Jeff Janes, 09.12.2012 23:41:
On Sun, Dec 9, 2012 at 2:36 AM, Thomas Kellerer wrote:
I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application
are failing when cleaning up my test database.
I am using the statement:
drop owned by wbjunit cascade;
at the end of a test
Jeff Janes, 09.12.2012 23:41:
I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application
are failing when cleaning up my test database.
I am using the statement:
drop owned by wbjunit cascade;
at the end of a test suite to get rid of everything that was created during
th
Zbigniew, 10.12.2012 04:20:
Yes, I read about using "savepoints" - but I think we agree,
it's just cumbersome workaround - and not real solution,
I disagree.
It might be a bit cumbersome, but it *is* a proper solution to the problem -
not a workaround.
Thomas
--
Sent via pgsql-general
Chris Angelico, 10.12.2012 16:47:
The other part of the problem is that you're using transactions for
something other than transactional integrity. You're batching up
transactions in order to improve performance. That's certainly
possible, but you're using the database "oddly", so you can't expec
Emi Lu wrote on 12.12.2012 17:17:
Good morning,
Is there a simple way to load UTF8 data in psql to mysql(with latin1 encoding)
through JDBC?
All you need to do is to query the source database, then use
ResultSet.getString() to obtain the data and use a PreparedStatement and
PreparedStatemen
Emi Lu wrote on 13.12.2012 15:00:
Is there a simple way to load UTF8 data in psql to mysql(with latin1
encoding) through JDBC?
All you need to do is to query the source database, then use
ResultSet.getString() to obtain the data and use a PreparedStatement and
PreparedStatement.setString() to
Edson Richter wrote on 14.12.2012 00:52:
I was wondering to create a tool for diagramming and database forward
engineering.
There are already few tools around.
If you know a good diagramming tool able to database diff and forward engineering (with "ALTER
...", not "DROP and CREATE"), I would
semi-ambivalent wrote on 16.04.2010 19:57:
I have some data fields that I have summed, grouped by a date field.
The sums are different. How can I then calculate the average value for
those sums? Everything I've tried errors out with something along the
lines of using agregates where I can't, or f
Ognjen Blagojevic, 21.04.2010 17:08:
More precisely, to run it without using TCP/IP port
No
and without installing as a service?
Yes (simply run pg_ctl "manually" from the command line)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Andy, 21.04.2010 01:44:
No I haven't. I'm using MySQL right now. But I want to learn more
about Postgresql's Hot Standby and see if it offers a better
replication solution.
Can anyone share their experience about Postgresql replication
performance impact? Thanks.
You might be interested in thi
dipti shah, 23.04.2010 13:17:
Thanks but I don't have text type in my table.
sysdb=# \d changelogtest
techdb=# INSERT INTO changelogtest (id, txid, txtime) values (5, 123, 'now')
except select id, txid, txtime
from changelogtest
where id=5;
'now' *is* a text type value
Thomas
--
Sent via pgs
Luís de Sousa, 26.04.2010 12:09:
Hello everyone,
I have an OpenOffice dabatase that I'd like to convert to Postgres.
More specifically I need to replicate tables, not null constraints,
primary keys, foreign keys, autonumbers and data. There's a tool that
does this with Microsoft databses:
http:
Andy Colson wrote on 29.04.2010 23:51:
Here is my query, which works:
select organization,
state,
(select max(idate) from times where customers.custid=times.custid and
taskid = 27) as lastdate,
age( (select max(idate) from times where customers.custid=times.custid
and taskid = 27) )
from custom
Sofer, Yuval wrote on 02.05.2010 09:27:
Hi
Postgres crashes with -
PG "FATAL: could not reattach to shared memory (key=5432001,
addr=0210): Invalid argument.
The version is 8.2.4, the platform is win32
Does someone know the reason/workaround ?
I think this is supposed to be fixed with 8
Greg Smith wrote on 02.05.2010 01:16:
Scott Ribe wrote:
PG's locking scheme, MVCC, basically precludes certain specific
optimizations that means a small number of very specific queries don't
perform as well, while at the same time it means that throughput with
multiple simultaneous connections s
Ovid wrote on 09.05.2010 15:33:
My apologies. This isn't PG-specific, but since this is running on
PostgreSQL 8.4, maybe there are specific features which might help.
I have a tree structure in a table and it uses materialized paths to
allow me to find children quickly. However, I also need to s
Richard Broersma wrote on 12.05.2010 17:45:
I'm considering using the windows version PostgreSQL in the following
conditions:
at least 10 years of up time (with periodic power failures<= 1 a year)
I don't think you can get 10 years of up time on a Windows Server.
Most of the security patches
Dino Vliet wrote on 16.05.2010 18:07:
Dear postgresql experts,
I want to know if postgresql has facilities for getting the first and or
the last in a by group.
Suppose I have the following table:
resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station,
arrival station, the class of
Yan Cheng CHEOK, 17.05.2010 03:21:
Recently, I try to introduce my friend to use PostgreSQL.
However, he first impression is that. PostgreSQL is much slower
compared to MySQL. He realize he has to wait for 7 seconds, to create
a tmp database.
Why on earth would anybody compare database perfor
Scott Marlowe, 17.05.2010 10:58:
Why on earth would anybody compare database performance using a command that
is usually executed only once in the lifetime of a database?
It's like saying "The car from manufacturer A is slower than the one from
manufacturer B, because it takes 1 second longer to
Dennis Gearon wrote on 18.05.2010 19:05:
select * from pg_class where relkind IN IN (‘r’, ‘v’, ‘S’);
^^ ^ ^
You repeated the keyword IN, and you are using the wrong quotes (unless this is a
copy & paste problem of a broken email client)
select *
fr
Magnus Hagander, 07.06.2010 15:52:
Some AV software probably behaves fine.
Probably.
In case anyone is interested:
I have two development computers that run Postgres on Windows XP.
One with Avira the other with Sophos.
Neither has or had any problems installing or running Postgres
Regards
Magnus Hagander, 07.06.2010 16:15:
On Mon, Jun 7, 2010 at 15:58, Thomas Kellerer wrote:
Magnus Hagander, 07.06.2010 15:52:
Some AV software probably behaves fine.
Probably.
In case anyone is interested:
I have two development computers that run Postgres on Windows XP.
One with Avira the
David Goodenough wrote on 20.06.2010 11:08:
I don't support anyone has written a "how to write database agnostic
code" guide? That way its not a matter of porting, more a matter of
starting off right.
I don't believe in "database agnostic code".
In the end it basically means that the applicat
mai fawzy, 22.06.2010 10:38:
I have a table that has the following fields:
IDMoney Date State
1 20 2010-01-01 done
2 10 2010-01-02done
I need to select the values from this table to join them 2 another
select statement but the pro
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and
plan to watch a
John Gage, 25.06.2010 11:50:
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector. Please disabuse
me of this idea if I am mistaken.
Getting really off-topic
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and
plan to watch a
Thomas Kellerer, 25.06.2010 14:32:
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org
Ravi Kariparmbil - Epistiuum Solutios, 28.06.2010 14:40:
Hello,
I am looking for a PostGre SQL trainer who can do a training program for
a client of mine in Bangalore.
I think this if off-topic here
And you should learn how to write the name correctly :)
Writing PostGre is like writing MerCe
Hi,
I was playing around with schemas and noticed that that the owner of a the
database (specified with the CREATE DATABASE command) is not the owner of the
database's public schema:
(Connect as super user)
c:\temp>psql postgres postgres
Password for user postgres:
psql (8.4.3)
Type "help" fo
Dennis Gearon, 05.07.2010 23:43:
I belong to MANY email listservers, probably like all of us.
All of them, I am on digest.
The CONTENT from all of you contributors is superior, more mature,
and more directly helpful than all the other lists. I think it has
something to do with the conservative,
GrGsM, 06.07.2010 09:06:
Now i need a column in the same result of the query which shows the
difference between the two columns .
For Example :
the result shoud be
Closedate , status , NT028, NT031, NT050,NT062 , NT028-NT031
Please note the last column in bold, i need the difference .
Alr
Hi,
I'm trying to download the ZIP archive for Postgres 8.3 on Windows, but I can't
find a download location where I do not need to register with EnterpriseDB
When I go to http://www.enterprisedb.com/products/download.do and click on the Windows
link for Postgres 8.3 I end up on the "Please re
Dave Page, 09.07.2010 10:20:
So how do I download the "binaries only" (no installer) bundle of Postgres
8.3 for windows?
EnterpriseDB don't produce one for 8.3. There is a copy from the old
MSI installer at http://www.postgresql.org/ftp/binary/v8.3.11/win32/,
but it's not binary-compatible with
Bruce Momjian wrote on 12.07.2010 21:34:
Thom Brown wrote:
Could someone clarify the info in this paragraph:
"Note that, due to a system catalog change, an initdb and database
reload will be required for upgrading from 9.0Beta1. We encourage
users to use this opportunity to test pg_upgrade for
Hi,
I'm trying pg_upgrade on my Windows installation and I have two suggestions
for the manual regarding pg_upgrade:
When specifying directories, pg_upgrade *requires* a forward slash as the path
separator. This is (still) uncommon in the Windows world (although Windows does
support it) and
Craig Ringer, 13.07.2010 05:11:
On 13/07/10 05:29, Thomas Kellerer wrote:
I would suggest to either manually change the autocommit mode from
within pg_upgrade or to add a note in the manual to disable/remove this
setting from psqlrc.conf before running pg_upgrade. Personally I think
the first
Thomas Kellerer, 12.07.2010 23:29:
Hi,
I'm trying pg_upgrade on my Windows installation and I have two
suggestions for the manual regarding pg_upgrade:
When specifying directories, pg_upgrade *requires* a forward slash as
the path separator. This is (still) uncommon in the Windows
Thomas Kellerer, 12.07.2010 23:29:
Hi,
I'm trying pg_upgrade on my Windows installation and I have two
suggestions for the manual regarding pg_upgrade:
I found another problem and I'm not sure if this is a bug or a user error :)
My batch file to start pg_upgrade looks
Hi,
the explanation of the --inserts option of pg_dumps states that
"The --column-inserts option is safe against column order changes, though even
slower."
The way I read this is, that
INSERT INTO table (column, ...) VALUES ...
is slower than
INSERT INTO table VALUES ...
Is that really tr
Tom Lane wrote on 16.07.2010 18:40:
Thomas Kellerer writes:
the explanation of the --inserts option of pg_dumps states that
"The --column-inserts option is safe against column order changes, though even
slower."
The way I read this is, that
INSERT INTO table (column, .
Craig Ringer wrote on 17.07.2010 03:13:
On 17/07/10 04:26, Thomas Kellerer wrote:
Hmm.
For years I have been advocating to always use fully qualified column
lists in INSERTs (for clarity and stability)
And now I learn it's slower when I do so :(
If you're not doing hundreds of th
Tom Lane wrote on 17.07.2010 16:36:
Thomas Kellerer writes:
I'm till a bit surprised that parsing the statement _with_ a column list is
mesurably slower than withou a column list.
Well, nobody's offered any actual *numbers* here. It's clear that
parsing the column list will
Thomas Kellerer wrote on 17.07.2010 18:29:
Want to do some experiments?
Apparently there *is* a substiantial overhead, but I suspected the
sending of the raw SQL literal to be a major factor here.
(Server and JDBC program were running on the same machine)
In case any one is interested.
Out
Tom Lane wrote on 17.07.2010 19:35:
Thomas Kellerer writes:
Tom Lane wrote on 17.07.2010 16:36:
Well, nobody's offered any actual *numbers* here.
I measured the runtime as seen from the JDBC client and as reported by explain analyze
(the last line reading "Total runtime:")
Howard Rogers, 28.07.2010 03:58:
Thanks to some very helpful input here in earlier threads, I was
finally able to pull together a working prototype Full Text Search
'engine' on PostgreSQL and compare it directly to the way the
production Oracle Text works. The good news is that PostgreSQL is
bloo
John Gage wrote on 06.08.2010 04:41:
But most people, including myself, don't even want to know the
documentation exists (for anything). We just want to plunge in and do it.
That just doesn't work and is an attitude that won't get you far.
In order to do things properly you need to learn and u
aravind chandu wrote on 07.08.2010 21:40:
Hello every one,
I have encountered a problem while working .I have a sample table with
the following data
*TID* *Date* *Item*
T1008/1/2010Laptop
T1008/1/2010Desktop
T1018/1/2010Laptop
T1028/1/2010Desktop
Alban Hertroys wrote on 08.08.2010 10:46:
On 7 Aug 2010, at 23:18, Thomas Kellerer wrote:
Or as an alternative:
SELECT tid, purchase_date
FROM orders
WHERE item in ('Laptop', 'Desktop')
GROUP BY tid, purchase_date
HAVING count(*) = 2
This one is incorrect, it will
Sandeep Srinivasa wrote on 09.08.2010 08:54:
The way I see it - for those who want to truly learn, there is the
documentation. For those who dont, there are ORMs.
Another of those ORM myths ;)
ORMs are not an alternative to learning SQL or understand how a DBMS works.
You need to be good at SQ
Stefan Wild wrote on 15.08.2010 10:36:
column is numeric, but upper() works on text, and returns
text, so your
numeric column got casted to text by using upper (which is
pointless
anyway - there is no "upper" version of digits).
remove upper() and you'll be fine.
Thank you guys! That was the
Mike Christensen, 27.08.2010 11:39:
Hi all -
I've noticed my log files for Postgres are getting way too big, since
every single SQL statement being run ends up in the log. However,
nothing I change in postgresql.conf seems to make a bit of
difference.. I've tried restarting postgres, deleting
Jayadevan M, 30.08.2010 11:26:
Hello all,
Has any one worked with Jira on PostgreSQL?
We are considering Jira implementation for our organization (about 1500
users).
The question is - "Jira on MySQL or Jira on PostgreSQL?" Any
tips/suggestions are welcome. We do not have much expertise in either
Jayadevan M, 30.08.2010 12:13:
Our admin team just moved our Jira from MySQL to PostgreSQL, but I
can't recall the exact reasons anymore. So far we do not have any
problems (from an end-user perspective that is)
Thanks for the reply. We plan to use it for our helpdesk, expecting it
to be up a
Carlos Mennens wrote on 10.09.2010 17:53:
On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma
wrote:
I don't believe there is a script like this. However, I would say
that out of the box, PostgreSQL is so secure that some people cannot
figure out how to log in. :)
I agree and I am just now l
Hi,
I would like to suggest to enhance the documentation of the CREATE VIEW
statement.
I think the fact that a "SELECT *" is internally stored as the expanded column
list (valid at the time when the view was created) should be documented together with the
CREATE VIEW statement. Especially bec
(This is the second time I send this, as the first message apparently did not
make it)
Dr. Peter Voigt, 30.09.2010 14:42:
If there are no other users out there with comparable problems I could
give the ZIP-installer a try under:
http://www.enterprisedb.com/products/pgbindownload.do
There is a f
Thom Brown wrote on 04.10.2010 20:40:
Hi all,
We're currently testing a new javascript change on the PostgreSQL
docs. This is to make sure monospaced fonts still appear at a
reasonable size between browsers. I'd appreciate it if some of you
could do some browser testing. http://magnus.webdev.
Thom Brown wrote on 04.10.2010 23:24:
Do you see the reduction in size compared to the live site an issue?
No, not at all.
I just wanted to mention it, in case you are interested.
I think both sizes are just fine.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Vorpal, 07.10.2010 02:53:
PostgreSQL was installed as part of other software.
The data folder is a subfolder of D:\Program Files\
Specifically:
"D:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N
"pgsql-8.3" -D "D:\Program Files\PostgreSQL\8.3\data\"
For various reasons I would li
Brandon Metcalf, 22.07.2008 12:36:
I've been able to find a couple of packages, but wondering if there is
a good system out there what will create an ER diagram of an existing
PostgreSQL DB. Open source would be nice.
Thanks.
Try Power*Architect, so far the best open source solution I have se
Stefan Berglund wrote on 16.08.2008 08:30:
[...]
>
First I install 8.3.1 using this command line:
> [...]
Next I do (after a reboot because the service name, service user, super
user, and super password are not known until after the reboot) an
install of version 8.3.3 using the following comm
Anderson dos Santos Donda wrote on 22.08.2008 22:53:
Hi all !!
On Windows, we can install the postgre 8.3 with a command, without
"windows setup" to install it, like on linux?
http://pginstaller.projects.postgresql.org/silent.html
--
Sent via pgsql-general mailing list (pgsql-general@
Scott Marlowe, 31.08.2008 22:44:
I think some of it is inertia. We've always used Oracle, let's just
keep on using it. The more conservative the IT department is, the
less likely they are to take chances with new technology.
It used to be there was about an 80/20 split between what things you
David Fetter, 01.09.2008 16:08:
because we are making extensive usage of Oracle's windowing
functions
http://umitanuki.net/pgsql/wfv04/design.html
I knew there was work going on regarding this, but I didn't know how definite
the decision was to integrate that into 8.4
It's too bad lead(), l
David Wall wrote on 15.10.2008 23:01:
Is there a way to get the PG version string from JDBC? I'm using PG 8.3.
Thanks,
David
In a portable manner:
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getDatabaseProductName()
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/
Mohammad Ali Darvish Darab, 05.11.2008 13:18:
Hello everybody,
I have got an already existing Porstgres DB which is pretty large
(including more than 650 table with considerable number of constraints
etc). And now I am supposed to realize generally how it is constructed
and works. I thought it w
Tom Lane, 07.11.2008 14:33:
Thomas Kellerer <[EMAIL PROTECTED]> writes:
are there any plans to support updating a tuple using a sub-select in one of
the future versions.
It's the first item under UPDATE on the TODO list ...
That is good news :)
Thanks
Thomas
--
Sent via pg
Gerhard Heift, 07.11.2008 13:35:
are there any plans to support updating a tuple using a sub-select in one of
the future versions.
e.g, something like:
UPDATE report_table
SET (order_count,order_value) = (SELECT count(*), sum(amount)
FROM order o
Gerhard Heift, 07.11.2008 14:47:
What about:
UPDATE report_table SET order_count = s_count, order_value = s_value
FROM (SELECT count(*) AS s_count, sum(amount) AS s_value FROM order o
WHERE o.customer_id = report_table.customer_id)
Its untested, but I think, it must works like this.
Inter
Hi,
are there any plans to support updating a tuple using a sub-select in one of
the future versions.
e.g, something like:
UPDATE report_table
SET (order_count,order_value) = (SELECT count(*), sum(amount)
FROM order o
WHE
Bruno Lavoie, 07.11.2008 19:20:
Hello,
The intent is to use pdftotext and store the resulting text in datbase
for full text search purposes... I'm trying to develop a mini content
server where I'll put pdf documents to make it searchable.
Generally, PDFs are in size of 500 to 3000 pages resu
Flavio Palumbo, 18.11.2008 10:01:
I tested this tool under MySql and Oracle and everything went as expected.
Unfortunately postgres seems to work in a different way, cause if there is
just one error while the transaction is active I'm not able to commit the
well formed data in the db, no matter
Erwin Moller, 18.11.2008 15:47:
Suppose I want to delete a record in tblnr1.
Does Postgres has some command/procedure/function to list tables that
have FK constraints on that table (tblnr1)
That could be resolved with a query against the INFORMATION_SCHEMA
Something like
SELECT c.table_name
Jonah H. Harris wrote on 18.11.2008 20:15:
On Tue, Nov 18, 2008 at 2:02 PM, Scara Maccai <[EMAIL PROTECTED]> wrote:
SELECT A FROM myTAB where A <1
only uses the index (if there's an index defined for A) in Oracle.
Well, not exactly. That's called a "covered" index because the query
could
Jonah H. Harris wrote on 18.11.2008 20:58:
On Tue, Nov 18, 2008 at 2:33 PM, Thomas Kellerer <[EMAIL PROTECTED]> wrote:
If all the columns from the select list are available in the index, then
Oracle will always prefer the index scan over a table scan (at least I have
never seen somethin
Tom Lane wrote on 20.11.2008 22:21:
"Josh Harrison" <[EMAIL PROTECTED]> writes:
My question is when I don't use the Recursive term does the optimizer just
consider it as a subquery or does it work like Oracle's WITH CLAUSE
(Subquery Factoring) ? Oracle's WITH CLAUSE boosts the performance of the
Bruce Momjian wrote on 20.11.2008 22:56:
From http://umitanuki.net/pgsql/wfv08/design.html I got the impression that
windowing functions will make into (at least partially) into 8.4 because on that
page several items are marked with [DONE].
I can't see anything in the developer docs regarding
Kevin Kempter wrote on 26.11.2008 20:46:
Hi All;
I'm selecting 3 columns. I want to order the results ascending by col1 and
col2 and then descending by col3
Whats the syntax for this?
ORDER BY col1 ASC, col2 ASC, col3 DESC
this is documented in the manual
--
Sent via pgsql-general maili
wild_oscar wrote on 03.12.2008 19:22:
I have been asked this question by some folks, and I have also asked the
question myself several times:
- Is there any good open source software that allows you to create a nice
UML representation of an already existing database running on Linux
Database ar
Scott Marlowe, 04.12.2008 16:34:
Like an Oracle DBA who told me
pgsql was broken because the output of group by wasn't properly
ordered like it was on Oracle 9.
Then he did not know Oracle very well :)
Even Oracle 9 does not guarantee that the output of an GROUP BY is actually sorted, with
weixiang tam wrote on 13.11.2009 10:16:
Dear all,
I am trying to install the postgres8.2.14 via the RPM; however the
install directory is default to the following folder
* Executables : /usr/bin
* Libraries : /usr/lib
* Documentation : /usr/share/doc/postgresql-x.y.z ,
/usr/
Willy-Bas Loos, 17.11.2009 12:15:
Hi,
Is there such a thing as a test dataset for postgresql?
Coming from the project i mean.
Cheers,
WBL
Try this:
http://pgfoundry.org/projects/dbsamples/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
Dave Coventry, 18.11.2009 14:23:
Tearing my hair out, can anyone see what I'm doing wrong?
SELECT title FROM node WHERE type=client;
ERROR: column "client" does not exist
LINE 1: SELECT title FROM node WHERE type=client;
You are missing the quotes to identify a character literal:
SELECT
Konstantin Izmailov, 17.11.2009 17:33:
This is why they want to use multiple statements
Which is not portable as well.
Actually the only database I know which permits sending more than one statement in
"one string" is SQL Server...
Thomas
--
Sent via pgsql-general mailing list (pgsql-gener
Massa, Harald Armin, 20.11.2009 11:07:
I have a table
CREATE TABLE rfmitzeit
(
id_rf inet NOT NULL,
id_bf integer,
wert text,
letztespeicherung timestamp without time zone
CONSTRAINT repofeld_id_rf PRIMARY KEY (id_rf),
);
where for one id_bf there are stored mutliple values ("wert") at
Massa, Harald Armin, 20.11.2009 11:31:
no, that does not work:
"id_bf";"wert";"max"
98;"blue";"2009-11-10 00:00:00"
98;"red";"2009-11-10 00:00:00"
result is: I get the date of the youngest value.
My expected result is:
98;"red"
(that is, the entry of "wert" that is youngest)
Sorry then I mi
Hi,
while using date_trunc('week', some_date) to get the date of the first day of the week I noticed that it was working as expected: Monday is considered the start of the week.
I assume this depends on some locale setting, but I can't figure out which it is, so I
can make sure this is not "a
501 - 600 of 804 matches
Mail list logo
