add_missing_from = on
Simple, just turn on the above option in postgresql.conf
and restart postgres service.
On Wed, Jun 4, 2008 at 5:35 PM, Holm Tiffe <[EMAIL PROTECTED]> wrote:
> A. Kretschmer wrote:
>
> > am Wed, dem 04.06.2008, um 12:47:41 +0200 mailte Holm Tiffe folgendes:
> > >
> >
On Wed, 4 Jun 2008 09:55:46 +0200
"A. Kretschmer" <[EMAIL PROTECTED]> wrote:
> am Wed, dem 04.06.2008, um 8:41:29 +0100 mailte Tarlika Elisabeth
> Schmitz folgendes:
> > I have 3 similar SELECTs. I am wondering whether they could be
> > rolled into one?
> >
> >
> > SELECT
> > item.id,
> > de
A. Kretschmer wrote:
> am Wed, dem 04.06.2008, um 12:47:41 +0200 mailte Holm Tiffe folgendes:
> >
> > Hi,
> >
> > I have to migrate an existing System from PostgreSQL 7 and 8.2.
> > There is a query that I'm not fully understand. It is running with
> > 7.3.21 generating two notices about missin
am Wed, dem 04.06.2008, um 12:47:41 +0200 mailte Holm Tiffe folgendes:
>
> Hi,
>
> I have to migrate an existing System from PostgreSQL 7 and 8.2.
> There is a query that I'm not fully understand. It is running with
> 7.3.21 generating two notices about missing FROM's:
>
> select poid,prodort.b
Hi,
I have to migrate an existing System from PostgreSQL 7 and 8.2.
There is a query that I'm not fully understand. It is running with
7.3.21 generating two notices about missing FROM's:
select poid,prodort.bez1 as prodort,sum(anz) as anz,
art,bez1 from best_dat where type='P' and relid=best_hdr
This turned out to be much simpler than I thought.
create view crm_script_details as
select *,
(CURRENT_DATE-(cs_age_max::text || 'months')::interval)::date as
start_date,
(CURRENT_DATE-(cs_age_min::text || 'months')::interval)::date as end_date
from crm_scripts;
On Wednesday 04 Ju
Hi folks
I've got the following table and view and I don't know exactly how to get what
I want.
The table contains integers for the number of months.
I want the view to convert those month integers to intervals that it can
add/subtract from a date.
create table crm_scripts (
cs_id in
am Wed, dem 04.06.2008, um 8:41:29 +0100 mailte Tarlika Elisabeth Schmitz
folgendes:
> I have 3 similar SELECTs. I am wondering whether they could be rolled
> into one?
>
>
> SELECT
> item.id
> department.id || section.id || category.id as x
Syntax error, missing , between the columns ;-)
I have 3 similar SELECTs. I am wondering whether they could be rolled
into one?
SELECT
item.id
department.id || section.id || category.id as x
FROM item
LEFT JOIN product ON ...
LEFT JOIN department ON ...
LEFT JOIN section ON ...
LEFT JOIN category ON ...
SELECT
item.id
department.id
