CODEWITHSUNDEEP
postgresqlrules
goh
goh

Reputation: 29521

postgresql creating rules on columns?

I need to format my SELECT queries on a text column. How may I do it without expliciting inserting it together with the query?

Do i use a rule in this case? I have tried creating a rule on the tables' column but apparently it won't work.

create or replace rule t_format AS ON SELECT TO site_ss_last_entry2
    DO INSTEAD
        select internet_date(site_ss.last_entry2) from site_ss;

Upvotes: 0

Views: 280

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 127297

Just create a VIEW and SELECT from this VIEW to get what you're looking for.

Upvotes: 2

Related Questions