agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
To: pgsql-sql@postgresql.org
Subject: Alternative SQL
Date: Sun, 14 Jan 2018 01:26:07 +0300
Message-ID: <000201d38cbd$8197c070$84c74150$@1nar.com.tr> (raw)

Hello,

I am using PostgreSQL 10.1 64bit on Windows 10 x64 system.

My database have following tables in it:
robox=# \dt
              List of relations
 Schema |        Name         | Type  | Owner
--------+---------------------+-------+-------
 public | aciliskapanis       | table | robox
 public | ameliyathaneler     | table | robox
 public | ameliyatlar         | table | robox
 public | errorlog            | table | robox
 public | guncellemetablolari | table | robox
 public | hastalar            | table | robox
 public | kaphareketleri      | table | robox
 public | kullanici           | table | robox
 public | malzemeler          | table | robox
 public | params              | table | robox
 public | personel            | table | robox
 public | sayimbaslik         | table | robox
 public | sayimdetay1         | table | robox
 public | sayimdetay11        | table | robox
 public | sayimdetay12        | table | robox
 public | sayimdetay2         | table | robox
 public | sayimdetay3         | table | robox
 public | sayimmakinalari     | table | robox
 public | sayimyazdir         | table | robox
 public | sifirlamalar        | table | robox
 public | updates             | table | robox
(21 rows)

I am using following SQL:
select 'aciliskapanis', max(kayitzamani) from aciliskapanis where serino =
'00000000de7de681'
union
select 'sayimbaslik', max(kayitzamani) from sayimbaslik where serino =
'00000000de7de681'
union
select 'sayimdetay1', max(kayitzamani) from sayimdetay1 where serino =
'00000000de7de681'
union
select 'sayimdetay11', max(kayitzamani) from sayimdetay11 where serino =
'00000000de7de681'
union
select 'sayimdetay12', max(kayitzamani) from sayimdetay12 where serino =
'00000000de7de681'
union
select 'sayimdetay2', max(kayitzamani) from sayimdetay2 where serino =
'00000000de7de681'
union
select 'sayimdetay3', max(kayitzamani) from sayimdetay3 where serino =
'00000000de7de681'
union
select 'errorlog', max(kayitzamani) from errorlog where serino =
'00000000de7de681'
union
select 'kaphareketleri', max(kayitzamani) from kaphareketleri where serino =
'00000000de7de681'
union
select 'sifirlamalar', max(kayitzamani) from sifirlamalar where serino =
'00000000de7de681'

Above SQL gives me following result and this is what I wanted. 
?column?	max
sayimdetay2	2018-01-13 23:24:29
errorlog	2018-01-14 00:08:56
sayimbaslik	2018-01-14 00:10:36
sifirlamalar	2018-01-13 23:19:07
sayimdetay11	2018-01-13 23:15:58
sayimdetay1	2018-01-14 00:10:42
sayimdetay3	2018-01-13 23:19:20
aciliskapanis	2018-01-14 00:12:44
sayimdetay12	2018-01-14 00:13:11
kaphareketleri	2018-01-14 00:13:33


But, it is not dynamic. Meaning, I am not using information in
guncellemetablolari table. guncellemetablolari table holds table names as
records that needs to be queried in my database. These records may change in
time. What I would like is an SQL (not a database function, if possible)
which gives me same result as above using records in guncellemetablolari
where guncellenir column is false. 

robox=# \dS guncellemetablolari;
Table "public.guncellemetablolari"
   Column    |  Type   | Modifiers
-------------+---------+-----------
 adi         | text    | not null
 guncellenir | boolean |
Indexes:
    "guncellemetablolari_pkey" PRIMARY KEY, btree (adi)


robox=# select * from guncellemetablolari;
      adi       | guncellenir
----------------+-------------
 ameliyatlar    | t
 hastalar       | t
 malzemeler     | t
 personel       | t
 aciliskapanis  | f
 sayimbaslik    | f
 sayimdetay1    | f
 sayimdetay11   | f
 sayimdetay2    | f
 sayimdetay3    | f
 sayimyazdir    | f
 errorlog       | f
 kaphareketleri | f
 sifirlamalar   | f
 sayimdetay12   | f
(15 rows)

Any help is appreciated.

Thanks & regards,
Ertan Küçükoðlu

Message-ID: <000201d38cbd$8197c070$84c74150$@1nar.com.tr>
Permalink:  ../000201d38cbd$8197c070$84c74150$@1nar.com.tr/
Also on:    postgresql.org/message-id/000201d38cbd$8197c070$84c74150$@1nar.com.tr

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ertan.kucukoglu@1nar.com.tr
  Subject: Re: Alternative SQL
  In-Reply-To: <000201d38cbd$8197c070$84c74150$@1nar.com.tr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox