8.14. View: sl_seqlastvalue

Figure 8-1. Definition of view sl_seqlastvalue

SELECT sq.seq_id
, 
    sq.seq_set
, 
    sq.seq_reloid
, 
    s.set_origin AS seq_origin
, 
    sequencelastvalue
(
     (
           (quote_ident
                 (
                       (pgn.nspname)::text
                 ) || '.'::text
           ) || quote_ident
           (
                 (pgc.relname)::text
           )
     )
) AS seq_last_value
   
FROM sl_sequence sq
, 
    sl_set s
, 
    pg_class pgc
, 
    pg_namespace pgn
  
WHERE (
     (
           (s.set_id = sq.seq_set)
         AND (pgc.oid = sq.seq_reloid)
     )
   AND (pgn.oid = pgc.relnamespace)
);