Re: [GENERAL] A table of magic constants

2015-07-14 Thread Alvaro Herrera
Dane Foster wrote: > Hi Michael, > > You nailed it. I am reading the documentation cover to cover. I started > chapter 9 two weeks ago but haven't found the time to read beyond 9.1 yet. > But for day to day usage on the MySQL to PostgreSQL migration project that > I'm working on I jump around in t

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Dane Foster
Hi Michael, You nailed it. I am reading the documentation cover to cover. I started chapter 9 two weeks ago but haven't found the time to read beyond 9.1 yet. But for day to day usage on the MySQL to PostgreSQL migration project that I'm working on I jump around in the docs as needed to find speci

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Michael Nolan
On Sat, Jul 11, 2015 at 4:53 PM, Vincent Veyron wrote: > On Sat, 11 Jul 2015 16:55:44 -0400 > Dane Foster wrote: > . After a while, you'll find your way around the documentation. > > I've been doing it almost every day for years, still learning every time. > I highly recommend reading the d

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Vincent Veyron
On Sat, 11 Jul 2015 16:55:44 -0400 Dane Foster wrote: > Thank you for the additional reference links but my concern was less about > how to find out what a function (formerly magic constant) that I > encountered in the wild did but more about having a list that would educate > newcomers/me about

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Adrian Klaver
On 07/11/2015 01:55 PM, Dane Foster wrote: Hello Adrian, Thank you for the additional reference links but my concern was less about how to find out what a function (formerly magic constant) that I encountered in the wild did but more about having a list that would educate newcomers/me about what

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Charles Clavadetscher
eaning. Maybe it helps. Bye Charles From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dane Foster Sent: Samstag, 11. Juli 2015 22:56 To: Adrian Klaver Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] A table of magic constants Hello

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Dane Foster
Hello Adrian, Thank you for the additional reference links but my concern was less about how to find out what a function (formerly magic constant) that I encountered in the wild did but more about having a list that would educate newcomers/me about what is automatically available for use. For exam

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Adrian Klaver
On 07/11/2015 12:21 PM, Raymond O'Donnell wrote: On 11/07/2015 20:07, Dane Foster wrote: As a recent convert to the Church of Postgres I've been consuming vast Welcome to the One True Faith! :-) amounts of information on PostgreSQL, and SESSION_USER is not the first nor only, what I'm cal

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Raymond O'Donnell
On 11/07/2015 20:07, Dane Foster wrote: > As a recent convert to the Church of Postgres I've been consuming vast Welcome to the One True Faith! :-) > amounts of information on PostgreSQL, and SESSION_USER is not the first > nor only, what I'm calling magic constant, that I've seen. Off the top

[GENERAL] A table of magic constants

2015-07-11 Thread Dane Foster
Hello, My reason/excuse for asking what I'll eventually ask is that I'm a new PostgreSQL practitioner so the amount of things I don't know about PostgreSQL is depressingly large. While reading through the recent "Row level security - notes and questions" thread I saw this SQL statement: CREATE P