On Thursday 24 May 2012, Elrich Marx wrote:
> If source changes, in this case from 1 to 2, then etime would be the
> last value of stime for source =1; So for source 1 it starts at
> stime 13:00 and continues till 13:02 (etime).
>
> This should result in 3 records, because source is 1, then 2, the
Yes, the system column "tableoid" identifies the actual table in which the
row is stored. If you cast this to "regclass" you'll get the name of the
table that the row is stored in:
SELECT tableoid::regclass FROM base_table;
There's more documentation on this available at
http://www.postgresql.org
On May 24, 2012, at 2:01 PM, George Woodring wrote:
> Is it possible to identify which inherited table data came from in a query?
> We have a table that has 3 inherited tables attached to it. I am looking for
> a way to identify the source of the data.
>
> My only thought would be to add a
Is it possible to identify which inherited table data came from in a query?
We have a table that has 3 inherited tables attached to it. I am looking
for a way to identify the source of the data.
My only thought would be to add a column to the tables that identify the
table. I was just checking
Hi
Le 22/05/2012 19:13, Carlos Mennens a écrit :
Hello everyone! I wanted to ask the list a question about the 'bytea'
data type& how I can picture this in my head. I've been reading SQL
for about a few months now and since then, I've only been working with
textual data. Basically I'm familiar
HI Raj
If source changes, in this case from 1 to 2, then etime would be the last
value of stime for source =1; So for source 1 it starts at stime 13:00 and
continues till 13:02 (etime).
This should result in 3 records, because source is 1, then 2, then 1 again.
I hope this explains ?
-Origin
On Thursday 24 May 2012, Elrich Marx wrote:
> I am quite new to Postgres, so please bear with me.
>
> I have a table with data in the following format:
>
> Table name : Time_Source_Table
>
> Source , Stime
> 1, "2012-05-24 13:00:00"
> 1, "2012-05-24 13:01:00"
> 1, "2012-05-24 13:02:00"
> 2, "20
Good day.
I am quite new to Postgres, so please bear with me.
I have a table with data in the following format:
Table name : Time_Source_Table
Source , Stime
1, "2012-05-24 13:00:00"
1, "2012-05-24 13:01:00"
1, "2012-05-24 13:02:00"
2, "2012-05-24 13:03:00"
2, "2012-05-24 13:04:00"
Hi, Gary,
Unless I'm mistaken this didn't give what you need.
Could you please tell me (if you have time) the error returned or wrong
result, just for my own understanding of where I've gone sideways on
this...?
Best,
Oliver
- Original Message -
From: "Oliveiros d'Azevedo Cristina"
On Thursday 24 May 2012 09:17:00 Pavel Stehule wrote:
> please, WHERE (ud_id, ud_pex_registration) = (SELECT ...
>
> replace by
>
> WHERE (..) IN (SELECT ..
>
> Regards
>
> Pavel
Worked perfectly, thank you
--
Gary Stainburn
Group I.T. Manager
Ringways Garages
http://www.ringways.co.uk
--
Se
>
> This was more like what I was thinking, but I still get an error, which I
> don't understand. I have extracted the inner sub-select and it does only
> return one record per registration. (The extra criteria is just to ignore old
> or cancelled tax requests and doesn't affect the query)
>
> goo
On Wed, May 23, 2012 at 12:07 PM, Lee Hachadoorian <
lee.hachadooria...@gmail.com> wrote:
> On Wed, May 23, 2012 at 5:24 AM, Ferruccio Zamuner
> wrote:
> > Hi,
> >
> > I like PostgreSQL for many reasons, one of them is the possibility to use
> > sub query everywhere. Now I've found where it doesn
12 matches
Mail list logo
