On Thu, 2004-11-11 at 15:31, Bob Powell wrote:
My systems admin says that he needs to have use of the Postgres user
without a password. His Debian package manager requires this.
The PostgreSQL user postgres is given the ability to connect to any
database on the local machine without
Title: query with table alias
Hello,
I think I have found a query problem when the query has an alias for a table and use alias item and table name.
I ilustrate the problem with a simple table and query.
prr=# create table foo (c1 int2, c2 int2);
CREATE TABLE
prr=# insert into foo
On Nov 12, 2004, at 7:48 PM, Rodríguez Rodríguez, Pere wrote:
prr=# select foo.c1, f.c2 from foo f; -- Incorrect result
c1 | c2
+
1 | 1
2 | 1
1 | 2
2 | 2
(4 filas)
If you alias a table, you can only reference the table using the alias.
It is in effect renamed: foo is no
Title: query with table alias
The
correct query would be "select f.c1, f.c2 from foo f;" if
you want to use alias
Patrick
---
Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36
18
prr=# select foo.c1, f.c2 from foo f; -- Incorrect result
The result of the select foo.c1, f.c2 from foo f isn't correct, it do
a cartesian product of foo table.
foo is aliased to f, so there's no table named foo in the from clause.
By default postgres tries to add the missing table name, so
If 2 days are equal for color red, you still would get 2 rows returned.
Maybe the below is accurate.
SELECT g.color, g.date, g.entered_by
FROM giventable g
WHERE g.color = 'red'
AND g.date =
(SELECT MAX(g2.date)
FROM giventable g2
Hello all,
I have accidently :-) found 'initlocation' and now I like to
know, how many secondary database i can create.
I like to do that, because I have a Virtual Webserver and for
each VirtualHost I have a local $USER. Now I like to create
seperatly secondary databases for each $USER/VHost.
On Thu, Nov 11, 2004 at 04:29:38PM -0700, Steve Crawford wrote:
True. I hadn't come up with a good time to get past that 7.4.1 -
7.4.2 initdb requirement. I guess I'll have to go with the manual
method.
IIRC, the initdb is recommended, but not required. It can be done
without an initdb too.
As many as you have disk space for I guess. You might need one
postmaster per location but I'm not sure about that, check the docs...
On Fri, Nov 12, 2004 at 04:18:13PM +0100, Michelle Konzack wrote:
Hello all,
I have accidently :-) found 'initlocation' and now I like to
know, how many
Hello Martijn,
Am 2004-11-12 17:01:20, schrieb Martijn van Oosterhout:
As many as you have disk space for I guess. You might need one
postmaster per location but I'm not sure about that, check the docs...
I have read, that the secondary databases are attached to the main
database which mean,
[Top-posting fixed]
On Fri, Nov 12, 2004 at 09:06:08AM -0500, Goutam Paruchuri wrote:
Scott Frankel wrote:
ORDER BY DESC LIMIT 1 is much simpler and more readable than a
sub-query. Though the sub-query approach looks to be a good template
for ensuring more accurate results by being more
On Nov 12, 2004, at 8:24 AM, Michael Fuhr wrote:
[Top-posting fixed]
On Fri, Nov 12, 2004 at 09:06:08AM -0500, Goutam Paruchuri wrote:
Scott Frankel wrote:
ORDER BY DESC LIMIT 1 is much simpler and more readable than a
sub-query. Though the sub-query approach looks to be a good template
for
The my2pg.pl script creates custom functions that help with the MySQL
set column type. I can't figure out how to use the functions once I
have the database migrated into Postgres.
Can someone please explain how to make use of them?
In MySQL, the table exists:
CREATE TABLE accessright (
How does one embed a sub-query lookup to one table in order to
replace a foreign key id number with it's name in a SELECT on a
second table?
i.e.: given the following two tables, I want to replace the color_id
of 1
with the color_name 'red.' (The SQL to create the two tables follows
below.)
something == otherthing is a boolean expression, you are asking the
database to compare both values, u.color_id is not equal c.color_name,
that's why you get 'f'.
I guess that you want to replace the color_id from users by the
corresponding color_name from colors:
SELECT
c.color_name,
Scott Frankel [EMAIL PROTECTED] writes:
Here's my query:
SELECT (
u.color_id = (
SELECT c.color_name
FROM colors c
WHERE color_id = 1)) AS color_name,
u.name, u.the_date
FROM users u
WHERE u.color_id
On Fri, Nov 12, 2004 at 09:52:09AM -0800, Scott Frankel wrote:
How does one embed a sub-query lookup to one table in order to
replace a foreign key id number with it's name in a SELECT on a
second table?
You're talking about joins.
On Fri, Nov 12, 2004 at 11:26:14AM -0700, Michael Fuhr wrote:
There are at least four ways to write the join query you want:
I may have misunderstood what results you're looking for, but the
examples I gave may nevertheless be useful. Sorry if they cause
any confusion.
--
Michael Fuhr
On Friday 12 November 2004 7:54 am, Martijn van Oosterhout wrote:
On Thu, Nov 11, 2004 at 04:29:38PM -0700, Steve Crawford wrote:
True. I hadn't come up with a good time to get past that 7.4.1 -
7.4.2 initdb requirement. I guess I'll have to go with the manual
method.
IIRC, the initdb is
Marc G Fournier [EMAIL PROTECTED] writes:
We are doing that specifically for that reason ... In order to provide
redundancy, we currently have two mail-news gateways of the mailing
lists in place, and the MessageIds are what prevents duplicates ...
Yeah, I just found out about that today.
Mike Cox [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]
berlin.de:
Uhh. My head is spinning with the complexity of this. Marc is fine with
being in the big eight official *if* the groups stay the same and it
doesn't affect the mailing list. This will just have to be a bug in the
system if
On Sunday, in article [EMAIL PROTECTED]
[EMAIL PROTECTED] Mike Cox wrote:
Also, he pointed out that for those who want to get the postgresql groups
when their usenet sever doesn't carry them, the solution would be to point
their newsreaders to news.postgresql.org.
Which only confirms my
Tom Lane wrote:
Is it possible to dump a database on a 7.4.6 server and then restore it
on a 7.4.1 server?
Should work, but why aren't you updating the 7.4.1 server? There were
some pretty nasty bugs fixed between .1 and .6.
problem is i dont have full power over that machine.
i will try to
stig erikson [EMAIL PROTECTED] writes:
i could not find any official builds for rh8, does the rh9 rpms work?
Doubtful. What I'd recommend is getting the source RPM and building your
own binary RPMs --- that's pretty much certain to work. All you need
is
rpmbuild --rebuild
--- Brian {Hamilton Kelly} [EMAIL PROTECTED] wrote:
Which only confirms my opinion that he's a fuckwit.
Evidently some of the nastiness out there on Usenet is
propagating into our lists in advance of any change.
__
Do you Yahoo!?
Check out
On Sun, 7 Nov 2004, Russ Allbery wrote:
Yeah, I understand it's not how the groups are set up, but it does seem
a little confusing. (Posting to a Usenet newsgroup and getting an
e-mail reply saying that my mailing list message is being held for
approval, for example.) I think it's a really
On Thu, Nov 11, 2004 at 11:55:33AM +0100, Bjørn T Johansen wrote:
select to_char((Log_Fortrykk.SistePlate::time -
OrdreNew.SistePlate::time)::interval,'HH24:MI') as diff from Log_Fortrykk
I need the output to be HH:MM, e.g. 00:09... But my prb is when this diff
is less than 0, it shows
On Sat, 13 Nov 2004, Gary L. Burnore wrote:
This isn't about encouraging ISP's to carry your lists. It's about
fixing a problem caused by your list's gateways.
A problem that you perceive, yet nobody else seems to ... very isolated
problem ... of coufse, you *could* set the group to moderated on
28 matches
Mail list logo