Huxton'; pgsql-sql@postgresql.org
Subject: Re: [SQL] Is there a bug in PostgreSQL ?
Pascal Tufenkji ptufen...@usj.edu.lb 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 8.2.7, which contains
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 schrieb Pascal
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
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:
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 the following error.
Can anyone help me plz
Thx
Pascal
select *
from sip_vacations_v v
left join
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 =
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
ON table TO sti;
I'd appreciate any help regarding this issue
Pascal Tufenkji
, 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 from pg_group where groname = 'sti
