unsubscribe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Thomas Good wrote:
Hi,
I am wondering if there is a way to set conditions on a left joined
table without hosing the join altogether:
query = qq |SELECT p.*, a.user_id
FROM patient_dosing p
LEFT JOIN patient_assignment a
ON p.patient_id = a.patient_id
Jason Turner <[EMAIL PROTECTED]> writes:
> My initial guess is that it is not able to utilize the index on
> foo.tracktitle to sort the result set after foo has been joined with
> other tables.
Well, of course not. It should be able to do it before, though, and I'm
a bit surprised that you didn't
alessandra de gregorio <[EMAIL PROTECTED]> schrieb:
> Hi,
>
> What function should I use to get a serial number, together with my results,
> from a query?
>
> Ex. Of output I want:
>
> 1 ooo pp ij
> 2 hou joo iu
> 3 bhi ft yh
>
> Basically, I would l
In article <[EMAIL PROTECTED]>,
"alessandra de gregorio" <[EMAIL PROTECTED]> writes:
> Hi,
> What function should I use to get a serial number, together with my results,
> from a query?
> Ex. Of output I want:
> 1 ooo pp ij
> 2 hou joo iu
> 3 bhi ft yh
On Nov 4, 2005, at 9:47 AM, [EMAIL PROTECTED] wrote:
The problem is I am very concerned about scalability with having a
different
table created for each custom object. I want to design to site to
handle
tens of thousands of users. If each user has 3-5 custom objects the
database would hav
> On Nov 4, 2005, at 9:47 AM, [EMAIL PROTECTED] wrote:
>
>> The problem is I am very concerned about scalability with having a
>> different
>> table created for each custom object. I want to design to site to
>> handle
>> tens of thousands of users. If each user has 3-5 custom objects the
>> data
Hi,
I use pg 8.03 (come with FC4). I can not connect to pg
because of Ident authentication failed for user "root"
error. pg_hba.conf
host all all 127.0.0.1/32 ident sameuser
Then I try another way by add adding a row to pg_indet
so that I can use root account to connection to db.
mymap root
