Re: [SQL] Is there a bug in PostgreSQL ?

chard Huxton'; pgsql-sql@postgresql.org Subject: Re: [SQL] Is there a bug in PostgreSQL ? "Pascal Tufenkji" writes: > Actually I'm using PostgreSQL 8.2.4 Well, in that case the answer to $SUBJECT is "Yes". Please update to something reasonably current --- at least

Re: [SQL] Is there a bug in PostgreSQL ?

I can't, it's an integer column ?! -Original Message- From: Andreas Kraftl [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2008 11:47 AM To: [EMAIL PROTECTED] Subject: Re: [SQL] Is there a bug in PostgreSQL ? Am Donnerstag, den 11.12.2008, 11:33 +0200 schr

Re: [SQL] Is there a bug in PostgreSQL ?

't it ! I'd appreciate any help Pascal -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2008 7:45 PM To: [EMAIL PROTECTED] Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Is there a bug in PostgreSQL ? Pascal

[SQL] Is there a bug in PostgreSQL ?

Hello, I'm writing a query with a left join to a view, and the server is giving me a wrong result. SELECT emp_id,institution from sip_carriere where emp_id = 342 and institution = 1; emp_id | institution +- 342 | 1 (1 row) SELECT * from sip_demissi

[SQL] Permission denied for create table

Hello, I'm doing a workshop for my students and I'm teaching them how to create tables in Postgres. So I created a database for every student, but I'm facing the following problem: sql073751=> CREATE TABLE emp1 (id int); CREATE TABLE sql073751=> SELECT * into emp2 from emp; ERROR: emp:

Re: [SQL] Subqueries

roupe = v.groupe; I not sure about the count(pl.id <http://pl.id/> ) * 1.5 is the same that you are looking for because it will depend of what you ate looking for. Regards On Thu, Oct 30, 2008 at 10:17 AM, Pascal Tufenkji <[EMAIL PROTECTED]> wrote: Hello, I don't understand

[SQL] Subqueries

Hello, I don't understand the following error. Can anyone help me plz Thx Pascal select * from sip_vacations_v v left join ( select pe.emp_id,mg.mat_id,mg.groupe,count(p.id) * 1.5 as nb_heures from mat_grp_v mg inner join planification_v p on p.mat_grp_id = mg.id

[SQL] ANSI Standard

Hi, How do I know if a function (or a certain sql syntax) in Postgres is a SQL ANSI Standard, hence it works on all databases such as MySQL, SQL Server, Oracle. I noticed that concat, decode, nvl, instr are functions that work for some databases and don't for others. I only want to use ANS

Re: [SQL] Postgres roles

ry 08, 2008 3:54 PM To: [EMAIL PROTECTED] Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Postgres roles Pascal Tufenkji wrote: > My questions are: > > > > 1. how do I identify the users assigned to this role : > (in the older version) > SELECT grolist f

[SQL] Postgres roles

ion) GRANT SELECT ON table TO group sti; GRANT SELECT,INSERT,UPDATE,DELETE ON table TO sti; I'd appreciate any help regarding this issue Pascal Tufenkji

[SQL] retrieve row number

Hi, Can I retrieve the row number in a select statement? For example : if I have the following table "foo" col1 | col2 -+- a | x b | y c | z select ?? as row_number, col1, col2 from foo; I should obtain the following result : row_number | col1 | col2 -