You're right, Reinoud. Sorry for my mystake...
Reinoud van Leeuwen wrote:
On Fri, Mar 12, 2004 at 10:54:25AM -0300, Daniel Henrique Alves Lima wrote:
Gary Stainburn wrote:
Hi folks,
I've got a table which contains amongst other things a stock number and a
registration numbe
Gary Stainburn wrote:
Hi folks,
I've got a table which contains amongst other things a stock number and a
registration number. I need to print out a list of stock number and reg
number where reg number is not unique (cherished number plate transfer not
completed). I've tried variations of a
I've made a test and it seems ok to me. I'm using utf-8 encoding
under postgresql 7.3.3.
Tom Lane wrote:
"Rute Solipa" <[EMAIL PROTECTED]> writes:
it seems that the pg_dump command doesn't keep the encoding information.
As of 7.4.2 it does emit a SET client_encoding.
In prior release
Hi, everybody !
I don't know if this is the best list to ask this question but if it
doesn't, please forgive me (should i try pgsl-general, maybe ?)...
We have a postgresql database in production and i've 2 questions
about pg_dumpall boring me. We "dump" both ddl and data as SQL command
Where can i find the documentation about "except" or "textcat" ?
I've looked at html docs in my machine (i've a 7.34 copy) and i
couldn't found information/sample of them.
Thanks.
---(end of broadcast)---
TIP 7: do
How about this:
select cd_area from area a1 where
not exists ((select 1,2 union select 98,45 union select 11,0) except
select c2.cd_teacher,c2.cd_course from teacher_course c2 where
c2.cd_course=a1.course)
?
Tom Lane wrote:
Daniel Henrique Alves Lima <[EMAIL PROTECTED]> writes:
Tomasz Myrta wrote:
Can you try this query ? :
select cd_area from area a1
join teacher_course c2 using (cd_course)
where (cd_teacher,cd_course) in (select 1,2 union select 98,45 union
select 11,0);
Tomasz, the "in" in the query above will work like an "or"
((cd_teacher=1,cd_course=2) or (c
Hi guys, i have a new question about how to simplify a query. I have
the tables area_course(cd_area,cd_course) and
teacher_course(cd_teacher,cd_course) and a set of pairs of values
{(1,2),(98,45),(11,0),...}.
Now, i must to select the areas which courses appears in
teacher_course and mat
Thank you, Jeremy.
I've built a function that returns a string from (cd_teacher, cd_course)
and i've create a functional index over this function, like :
create index teacher_course_idx on teacher_course
(build_unique_2p(cd_teacher,cd_course));
select * from teacher_course where build_unique_2p
Is there a way to create a "functional index" over a string
concatenation of two columns ?
Thanks.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hello, everybody.
I've a simple question about SQL usage but i don't know even i can
formulate this question. Well, i will try :
I've a teacher_course table with columns cd_course, cd_teacher =>
teacher_course(cd_teacher,cd_course) and i've a set of pairs that
contains the values for t
11 matches
Mail list logo
