Zdeněk Kotala a écrit :
I prepared patch for renaming postgreSQL script tools like createdb,
createuser, etc. to pg_createdb, pg_creteuser. Original names will be
kept for 2 or 3 following versions. The main reason for the patch is to
avoid possible clash of names with systems tools.
And
On Wed, Mar 26, 2008 at 05:28:18PM -0500, Seb wrote:
INSERT INTO my_table (var_bool) VALUES ( CAST( 0 AS BOOLEAN )); or
INSERT INTO my_table (var_bool) VALUES (0::BOOLEAN);
Thanks Richard. Is there a way to do it without changing the INSERT
command? As I mentioned, there are many more
On Wed, Mar 26, 2008 at 07:58:25PM -0400, John DeSoi wrote:
I notice that when I build 8.3.1 psql on OS X (10.5.2) there is now a
library dependency on /usr/lib/libgcc_s.1.dylib.
It appears to be a support library for gcc for certain routines that
are architecture specific or language
Please let us know your meaning,
1) What type of names do you prefer?
---
a) with c) as a second choice. Keep names simple.
2) How often do you use these tools?
---
a)
3) What name of initdb do you prefer?
--
On 27/03/2008, Zdeněk Kotala [EMAIL PROTECTED] wrote:
1) What type of names do you prefer?
---
a) old notation - createdb, createuser ...
a) Never seen any clashes with other tools in terms of names.
And the old sys-admin creed: don't fix it if it ain't
Zdeněk Kotala pisze:
Hello All,
1) What type of names do you prefer?
b) new one with pg_ prefix - pg_createdb, pg_creteuser ...
b
2) How often do you use these tools?
b) one per week
b
3) What name of initdb do you prefer?
c) pg_init
c
4) How do you perform VACUUM?
a) vacuumdb - shell
Hello,
i'm the maintainer of the ASP.NET PostgreSQL Provider.
You'll find the latest sources and documentation on the project home
page at: http://dev.nauck-it.de/aspsqlprovider/
There is also a ready to run example website:
http://dev.nauck-it.de/aspsqlprovider/browser/example
Currently
Hi,
Thank you for you detailed answer, but I am exactly in the case when I
want to paste the script and hit F5 and have both the database and
tables created.
A problem also comes from the fact that in order to use the query window
in pgadmin3, you need to select a database. Then when you
Albe Laurenz wrote:
srdjan wrote:
I'll try to explain my problem with an example.
-- I've got 2 tables and one view
CREATE TABLE a (name varchar(20) primary key, num integer);
CREATE TABLE b (town varchar(15), name varchar(20) references a(name));
CREATE VIEW vvv AS SELECT * FROM a
Hi
Iam trying to update a database table with approx 45000 rows. Iam not
updating all rows at a time. Iam updating 60 rows at a given time for
example. and this is happening in a FOR LOOP. A function that has the
update statements is called within the loop.
The updates take too long.is
I work at a fairly large company 2000 people just at my site alone.
I've been given access to a new database which will be used for source
data for some software that the company just purchased.
Now this PostGreSQL server has many databases in it. Some of which I
have access to. I don't want to
sam wrote:
Hi
Iam trying to update a database table with approx 45000 rows. Iam not
updating all rows at a time. Iam updating 60 rows at a given time for
example. and this is happening in a FOR LOOP. A function that has the
update statements is called within the loop.
The updates take too
Albe Laurenz wrote:
srdjan wrote:
What is the desired response to
INSERT INTO vvv (name, town, num) VALUES ('Karl', 'Leipzig', 18);
Should this generate an error message, do nothing, or insert something?
In this case you shouldn't be able to do this insert.
Should it
hi,
i would like to know how can i control the returned value from a SQL
statement ?
for example, if i do an INSERT INTO... :
1. how can i know if the INSERT worked ?
i mean i already trapped the unicity violation, but what if there is another
error ? where can i get a complete list of exceptions
In article [EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] writes:
I note that we can continue to have the current executables stashed in
PREFIX/share/libexec and let the pg executable exec them.
Not share/ surely, since these are executables, but yeah.
This brings me to the idea that pg is a
Alain Roger wrote:
hi,
i would like to know how can i control the returned value from a SQL
statement ?
You've left out some pretty significant information, like what method
you're using to access PostgreSQL.
ODBC from C/C++/whatever?
PHP?
Perl DBD?
Python DBI?
The .net interfaces?
Alain Roger wrote:
hi,
i would like to know how can i control the returned value from a SQL
statement ?
for example, if i do an INSERT INTO... :
1. how can i know if the INSERT worked ?
i mean i already trapped the unicity violation, but what if there is another
error ? where can i get a
thanks for the link regarding errors... i did not find it before.
On Thu, Mar 27, 2008 at 10:47 AM, Richard Huxton [EMAIL PROTECTED] wrote:
Alain Roger wrote:
hi,
i would like to know how can i control the returned value from a SQL
statement ?
for example, if i do an INSERT INTO... :
Pettis, Barry wrote:
Now this PostGreSQL server has many databases in it. Some of which I
have access to. I don't want to reinvent the wheel ( so to speak ) by
having to replicate the table in my database. Then having to create
routines that will extract from A to replicate in B. How do I
Alain Roger wrote:
sorry... under pl/pgsql as stored procedure
Then this question was already asked and answered less than a week ago
on this mailing list.
By you, with almost exactly the same subject line.
Forgive my confusion, but why are you asking the same question again?
What's changed
sorry... under pl/pgsql as stored procedure
On Thu, Mar 27, 2008 at 10:46 AM, Craig Ringer [EMAIL PROTECTED]
wrote:
Alain Roger wrote:
hi,
i would like to know how can i control the returned value from a SQL
statement ?
You've left out some pretty significant information, like what
not really.. but it is true that it can be confusing...sorry :-(
the purpose here, it is to solve my problem with a transaction inside a
function.
i need to know if there is a common return value for error in case of a SQL
statement failed.
it seems that not, so i would like to know if the
On Wed, 26 Mar 2008, sam [EMAIL PROTECTED] writes:
Iam trying to update a database table with approx 45000 rows. Iam not
updating all rows at a time. Iam updating 60 rows at a given time for
example. and this is happening in a FOR LOOP. A function that has the
update statements is called
On Wed, Mar 26, 2008 at 01:26:03PM -0700, Sam wrote:
Iam trying to update a database table with approx 45000 rows. Iam not
updating all rows at a time. Iam updating 60 rows at a given time for
example. and this is happening in a FOR LOOP. A function that has the
update statements is called
On Thu, Mar 27, 2008 at 11:25:18AM +0100, Alain Roger wrote:
not really.. but it is true that it can be confusing...sorry :-(
the purpose here, it is to solve my problem with a transaction inside a
function.
hum, I think PG works a little differently than you think. a function
is run inside
Pettis, Barry wrote:
An addon Being self schooled in databases to me this seems to be a
kludge.
Ah, well, self-schooling is always a good position from which to make
sweeping generalisations.
If you work in a large company environment the odds that
someone somewhere is all ready
I am experiencing a strange problem where autovacuum appears to be
vacuuming 1 table in preference to another even through they have very
similar usage patterns.
For this test case I have 2 tables, 'transactions' and 'lineitems', and
the ratio of writes is approx 1:3. I am filling these
sam wrote:
Iam trying to update a database table with approx 45000 rows. Iam not
updating all rows at a time. Iam updating 60 rows at a given time for
example. and this is happening in a FOR LOOP. A function that has the
update statements is called within the loop.
The updates take too
On Thu, Mar 27, 2008 at 12:40 AM, Martijn van Oosterhout [EMAIL PROTECTED]
wrote:
Don't think anyone mentioned it, but if you could get it to output
quotes around the value, like:
INSERT INTO my_table (var_bool) VALUES ('0');
It will also work.
This is good to know. There is an option in
Pettis, Barry wrote:
It sounds to me like you want to share a single database between
users,
possibly using a suitable mix of schemas and roles to apply suitable
permissions. If you don't want them to have shared access to the data
then you can have separate databases and grant them access
On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
It could be that but not necessarily. These could be pages that were
allocated to put new tuples into, but the crash happened
Shane Ambler wrote:
Greg Smith wrote:
And if anybody suggests putting a _ in something I have to type all
the time, I will stick my fingers in my ears and start yelling until
they stop. Bad enough I have to type pg_ctl a few times every day now.
+10 on hating _
+20 if need be, I'd go
Brad Nicholson wrote:
On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
It would be easier to believe that if the uninitialized pages were all
contiguous though. Do you
On Thu, 2008-03-27 at 10:29 -0300, Alvaro Herrera wrote:
Brad Nicholson wrote:
On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
It would be easier to believe that if
Alain Roger wrote:
the purpose here, it is to solve my problem with a transaction inside a
function.
You cannot handle transactions inside a function (apart from using EXCEPTION
blocks).
A PostgreSQL function is always executed in a single transaction.
All SQL statements you issue from
On Wed, 26 Mar 2008 18:03:06 -0500,
Seb [EMAIL PROTECTED] wrote:
On Wed, 26 Mar 2008 22:46:08 +,
Sam Mason [EMAIL PROTECTED] wrote:
[...]
You could turn the problem around and make the bool columns into ints
(which should be a simple search-and-replace, I hope) and then write
something
On Mar 26, 2008, at 12:26 PM, Joseph Shraibman wrote:
After I sent my last email, a light bulb went off. I remembered a
similar problem I had a while ago with parts of postgres not having
read permission. Sure enough after I
[EMAIL PROTECTED] /usr/local/pgsql]# chmod -R a+r *
then
Brad Nicholson [EMAIL PROTECTED] writes:
On Thu, 2008-03-27 at 10:29 -0300, Alvaro Herrera wrote:
Brad Nicholson wrote:
It was. This table is an insert only log table that was being heavily
was being heavily written to at the time of the crash.
Is it possible that there were *two* crashes?
Erik Jones [EMAIL PROTECTED] writes:
On Mar 26, 2008, at 12:26 PM, Joseph Shraibman wrote:
This is a IMHO a bug in the install script. All of the postgres
install should be world readable, regardless of the umask (or at
least provide a warning).
What? Are you actually saying that a PG
On Thu, 27 Mar 2008, Alvaro Herrera wrote:
Greg Smith wrote:
And if anybody suggests putting a _ in something I have to type all the
time...
alias pgctl=pg_ctl
If I were allowed to change the login profile on every system I touch I
wouldn't be typing pg_ctl at all; I'd be typing up and
Alvaro Herrera [EMAIL PROTECTED] writes:
Greg Smith wrote:
And if anybody suggests putting a _ in something I have to type all the
time, I will stick my fingers in my ears and start yelling until they
stop. Bad enough I have to type pg_ctl a few times every day now.
alias pgctl=pg_ctl
It sounds to me like you want to share a single database between
users,
possibly using a suitable mix of schemas and roles to apply suitable
permissions. If you don't want them to have shared access to the data
then you can have separate databases and grant them access only to
their
own
An addon Being self schooled in databases to me this seems to be a
kludge. If you work in a large company environment the odds that
someone somewhere is all ready storing or collecting data that you need
( by this I mean base data ) could probably be pretty high. So why, if
PostGre is so
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Greg Smith wrote:
And if anybody suggests putting a _ in something I have to type all the
time, I will stick my fingers in my ears and start yelling until they
stop. Bad enough I have to type pg_ctl a few times every day now.
Tom Lane wrote:
No, he's complaining that the share/timezone file tree wasn't
world-readable. I think that's plain old pilot error though.
The install script shouldn't be second-guessing the umask it's
given, any more than it second-guesses the file ownerships.
If binaries are made readable
Alain Roger wrote:
i would like to know how can i control the returned value from a SQL
statement ?
for example, if i do an INSERT INTO... :
1. how can i know if the INSERT worked ?
i mean i already trapped the unicity violation, but what if
there is another error ? where can i get a
No, not the pg data directory. The pg binaries. My problem was caused
by the timezone files installed under /usr/local/pgsql/share were not
world readable due the way I had the umask of root set when I did the
compile and install.
Erik Jones wrote:
What? Are you actually saying that a PG
On Sun, 2007-09-16 at 11:18 -0700, Jeff Davis wrote:
On Sun, 2007-09-16 at 09:25 +0100, Simon Riggs wrote:
Well, the definition of it working correctly is that a restored log
file... message occurs. Even with archive_timeout set there could be
various delays before that happens. We have two
On Thu, 2008-03-27 at 10:37 -0400, Tom Lane wrote:
What do you mean by two separate SAN switches pulled out --- is the
DB spread across multiple SAN controllers?
It's using IO mutilpath through 2 HBAs. Both of those were taken down.
Brad.
--
Sent via pgsql-general mailing list
1) What type of names do you prefer?
1 b
2) How often do you use these tools?
2 c
3) What name of initdb do you prefer?
3 e (pg_createcluster by Debian), then d or b
4) How do you perform VACUUM?
4 c b (autovac sql vacuum)
Regards,
Dawid
--
Sent via pgsql-general mailing list
On Wed, Mar 26, 2008 at 6:46 PM, Ron Mayer
[EMAIL PROTECTED] wrote:
Zdeněk Kotala wrote:
1) What type of names do you prefer?
I'd prefer a pg program that took as arguments
the command. So you'd have pg createdb instead
of pg_createdb.
There are many precedents. cvs update, git
Hi,
i've read several books extract about controlling loops in postgreSQL under
pl/pgsql and there is something interesting.
once to do a comparison they use :
IF (ret == 1) THEN ...
once,
IF (ret = 1) THEN...
so are they both correct ?
comming from .NET/C++ world, usually we use '==' or
-- Original message --
From: Alain Roger [EMAIL PROTECTED]
Hi,
i've read several books extract about controlling loops in postgreSQL under
pl/pgsql and there is something interesting.
once to do a comparison they use :
IF (ret == 1) THEN ...
once,
Hi,
i have a problem solving my function trouble.
this function should return an email address stored in a table
(tmp_newsletterreg) based on a number (sessions ID).
if the session id is not find it should return a string corresponding to and
error.
if the email in found but already exists into
this is what i did, and it's true that '==' does not exist under pl/pgsql.
Only '=' should be used.
On Thu, Mar 27, 2008 at 8:53 PM, Tom Lane [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] (Adrian Klaver) writes:
From: Alain Roger [EMAIL PROTECTED]
once to do a comparison they use :
IF (ret
[EMAIL PROTECTED] (Adrian Klaver) writes:
From: Alain Roger [EMAIL PROTECTED]
once to do a comparison they use :
IF (ret == 1) THEN ...
once,
IF (ret = 1) THEN...
Both are correct.
No they're not, as a simple test would convince you ...
there is no '==' operator in SQL.
Alvaro Herrera napsal(a):
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Greg Smith wrote:
And if anybody suggests putting a _ in something I have to type all the
time, I will stick my fingers in my ears and start yelling until they
stop. Bad enough I have to type pg_ctl a few
-- Original message --
From: Tom Lane [EMAIL PROTECTED]
[EMAIL PROTECTED] (Adrian Klaver) writes:
From: Alain Roger [EMAIL PROTECTED]
once to do a comparison they use :
IF (ret == 1) THEN ...
once,
IF (ret = 1) THEN...
Both are correct.
No
Zdenek Kotala wrote:
And what about two commands one for create and one for drop?
It save 6 or 4 chars.
pgc db (as create db)
pgc user
pgd db (as drop db)
pgd user
Well, there are things besides create and drop -- for example vacuum.
--
Alvaro Herrera
-- Original message --
From: Alain Roger [EMAIL PROTECTED]
Hi,
i have a problem solving my function trouble.
this function should return an email address stored in a table
(tmp_newsletterreg) based on a number (sessions ID).
if the session id is not find
Alvaro Herrera napsal(a):
Zdenek Kotala wrote:
And what about two commands one for create and one for drop?
It save 6 or 4 chars.
pgc db (as create db)
pgc user
pgd db (as drop db)
pgd user
Well, there are things besides create and drop -- for example vacuum.
Yeah, good point I forgot
On Thursday 27. March 2008, Alvaro Herrera wrote:
Zdenek Kotala wrote:
And what about two commands one for create and one for drop?
It save 6 or 4 chars.
pgc db (as create db)
pgc user
pgd db (as drop db)
pgd user
Well, there are things besides create and drop -- for example vacuum.
I
I'd like to add a table, state_neighbours, which joins each state with
all of its neighbour states. Does anyone know where I can find such a list?
I'm not interested in nearest neighbour, just any connected state.
eg. IA would be associated with {MN,WS,IL,MO,KS,NB,SD} and HI AK would
not be
Tom Lane napsal(a):
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane wrote:
I like this too. It'd be considerably more work than the currently
proposed patch, though, since we'd have to meld the currently
separate programs into one executable.
I note that we can continue to have the
Naz Gassiep napsal(a):
We're not seriously thinking of changing these are we? Once a command
set has been in use for as long a time as the PG command set has, any
benefit that may be derived by new users with an aversion to
documentation reading is vastly offset by the confusion that would
- Original Message -
From: Zdenek Kotala [EMAIL PROTECTED]
To: Naz Gassiep [EMAIL PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Thursday, March 27, 2008 4:31 PM
Subject: Re: [GENERAL] Survey: renaming/removing script binaries (createdb,
createuser...)
Naz Gassiep
brian wrote:
I'd like to add a table, state_neighbours, which joins each state with
all of its neighbour states. Does anyone know where I can find such a list?
I'm not interested in nearest neighbour, just any connected state.
That sounds like something you could create in 20 minutes with a
Colin Wetherbee wrote:
brian wrote:
I'd like to add a table, state_neighbours, which joins each state with
all of its neighbour states. Does anyone know where I can find such a
list?
I'm not interested in nearest neighbour, just any connected state.
That sounds like something you could
On Thu, Mar 27, 2008 at 08:43:46PM +0100, Alain Roger wrote:
i have a problem solving my function trouble.
this function should return an email address stored in a table
(tmp_newsletterreg) based on a number (sessions ID).
if the session id is not find it should return a string corresponding
On Mar 27, 2008, at 5:00 PM, Colin Wetherbee wrote:
brian wrote:
I'd like to add a table, state_neighbours, which joins each state
with all of its neighbour states. Does anyone know where I can find
such a list?
I'm not interested in nearest neighbour, just any connected state.
That
On Thursday 27 March 2008 3:17 pm, Sam Mason wrote:
On Thu, Mar 27, 2008 at 08:43:46PM +0100, Alain Roger wrote:
i have a problem solving my function trouble.
this function should return an email address stored in a table
(tmp_newsletterreg) based on a number (sessions ID).
if the session
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Yes, I understand your point of view, but on other side there
are arguments in discussion, that for newbies old name are
terrible to use and frankly, who reads manual before he start
to use a product?
This is a terrible argument.
Nobody
On Thu, 27 Mar 2008, Leif B. Kristensen wrote:
I figure something like the more or less standard options for modern
*nixes, with short and long options like eg.
pgc -C, --createdb ...
The idea thrown out was to use something like the CVS/svn model where a
single command gets called followed
Using 8.3
I have a table which has a column (tdr_tags) defined as integer[][]. The
table description shows the column as integer[]. I understand from the
docs that this is normal (declaring number of dimensions or sizes in
CREATE TABLE is simply documentation).
If I select the column as
On Thu, Mar 27, 2008 at 03:34:49PM -0700, Adrian Klaver wrote:
Or a simpler way to do handle my previous suggestion:
IF (ret_email IS NULL ) OR (ret_email='') THEN
RETURN ('-3')
That would be the sane fix, yes.
Based on the previous emails from the OP, he seems to be missing a
lot of
Zdenek Kotala [EMAIL PROTECTED] writes:
Naz Gassiep napsal(a):
So I ask again, we're not seriously thinking about this are we?
Yes, we are.
Make that Zdenek is. The reason for this survey is that he's hoping
to gather enough ammunition to overrule the opposition.
In any case, there *will*
On Thu, Mar 27, 2008 at 11:49 PM, Greg Smith [EMAIL PROTECTED] wrote:
On Thu, 27 Mar 2008, Leif B. Kristensen wrote:
I figure something like the more or less standard options for modern
*nixes, with short and long options like eg.
pgc -C, --createdb ...
The idea thrown out was to use
Dawid wrote:
[...]
abbreviations in cases where there's some overlap in characters:
pgc cluster
[...]
Agree, except I would prefer pg instead of pgc.
No can do, already taken:
man pg
Reformatting pg(1), please wait...
PG(1) User
Dawid Kuroczko escribió:
On Thu, Mar 27, 2008 at 11:49 PM, Greg Smith [EMAIL PROTECTED] wrote:
pgc cluster
Agree, except I would prefer pg instead of pgc.
pg is already taken by an ancient Unix pager utility (predecessor of
more, less, etc)
--
Alvaro Herrera
brian [EMAIL PROTECTED] writes:
If I select the column as tdr_tags I get:
{{161377},{32}}
{{206507},{39}}
{{232972,292831},{45,51}}
...
But, wanting just the 2nd inner array, if I try tdr_tags[2] I get NULL.
If you want a sub-array you need to use the slice notation, eg
Gregory Williamson wrote:
No can do, already taken:
man pg
Reformatting pg(1), please wait...
PG(1) User
Commands PG(1)
NAME
pg - browse pagewise through text files
Good catch. Haven't used
Ben [EMAIL PROTECTED] writes:
On Mar 27, 2008, at 5:41 PM, Tom Lane wrote:
Make that Zdenek is. The reason for this survey is that he's hoping
to gather enough ammunition to overrule the opposition.
Oh, then there should have been some options in the survey along the
lines of things are
On Mar 27, 2008, at 5:41 PM, Tom Lane wrote:
Zdenek Kotala [EMAIL PROTECTED] writes:
Naz Gassiep napsal(a):
So I ask again, we're not seriously thinking about this are we?
Yes, we are.
Make that Zdenek is. The reason for this survey is that he's hoping
to gather enough ammunition to
Em Thursday 27 March 2008 08:29:04 Pettis, Barry escreveu:
An addon Being self schooled in databases to me this seems to be a
kludge. If you work in a large company environment the odds that
someone somewhere is all ready storing or collecting data that you need
( by this I mean base
On 28/03/2008, Dawid Kuroczko [EMAIL PROTECTED] wrote:
Agree, except I would prefer pg instead of pgc.
With pg I am sure that the comand is generic to the extreme, so I don't
have to assume what does c stand for. Control? Create? Client? or
Command.
Also its about 33% shorter. ;-)
Oh, then there should have been some options in the survey along the
lines of things are fine how they are.
Oh, a bit of answer-forcing wasn't beneath him.
Ummm... Isn't that what Option A is about ?
1) What type of names do you prefer?
---
a) old notation
On Mar 26, 2008, at 7:25 AM, Zdeněk Kotala wrote:
1) What type of names do you prefer?
---
a) old notation - createdb, createuser ...
2) How often do you use these tools?
---
a) every day (e.g. in my cron)
b) one per week
c) one
Tom Lane wrote:
brian [EMAIL PROTECTED] writes:
If I select the column as tdr_tags I get:
{{161377},{32}}
{{206507},{39}}
{{232972,292831},{45,51}}
...
But, wanting just the 2nd inner array, if I try tdr_tags[2] I get NULL.
If you want a sub-array you need to use the slice notation, eg
Any chance we can an rpm for the plpgsql debugger to the rpms at
http://yum.pgsqlrpms.org/ ?
It would make it easier to install on systems that installed PGSQL from
rpm rather than from source.
Matt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Hi,
I'm not very savvy with interval manipulations, but I have a query like
this:
--cut here---start-
SELECT DISTINCT ON (table_a.id) table_a.id, table_a.var2,
EXTRACT(DAY FROM (table_b.date - table_a.date)) AS age,
FROM table_a INNER
Seb [EMAIL PROTECTED] writes:
EXTRACT(DAY FROM (table_b.date - table_a.date)) AS age,
Is this an efficient way to get the days from the time interval? Both
'date' columns are of type Date. Thanks.
Efficiency is moot, it's just plain wrong. Or at least something is
wrong here,
On Fri, 28 Mar 2008 00:06:59 -0400,
Tom Lane [EMAIL PROTECTED] wrote:
[...]
Efficiency is moot, it's just plain wrong. Or at least something is
wrong here, Subtraction of two date values gives an integer number
of days already, so I'd expect the EXTRACT to fail altogether. You
sure the
On Wednesday 26 March 2008 16:03, hubert depesz lubaczewski wrote:
On Wed, Mar 26, 2008 at 10:02:45AM -0700, Steve Atkins wrote:
What's the psql equivalent of the standard use case of vacuumdb -a?
(If you don't know the answer, for both unix and windows, you don't get
to vote for removing
If you are a student, or know a student, or are a professor ...
www.postgresql.org/developer/summerofcode
Please submit an application as soon as you can!
--Josh
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
I am fairly new to Postgres. However, I have to say that I agree with
Barry's comments.
The community's response is technically valid; they do talk about a better
way of 'designing' things, and what the company 'should' be doing.
However, coming from a MS-Sql world, people want multiple databases
95 matches
Mail list logo