Re: [GENERAL] Name spacing functions and stored procedures

2015-03-19 Thread Steven Erickson
functions and stored procedures Hi 2015-03-19 2:56 GMT+01:00 Tim Uckun mailto:timuc...@gmail.com>>: What do you guys do to namespace your functions so that they are not jumbled in with the system functions and also somewhat hierarchically organized. Obviously it's possible to create

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-19 Thread Pavel Stehule
2015-03-19 11:46 GMT+01:00 Pavel Stehule : > > > 2015-03-19 11:03 GMT+01:00 Tim Uckun : > >> I guess I see schemas as ways to group data not functions. >> >> It would be very nice to be able to group your code into proper modules >> though. It's something I really miss. >> > > what is advantage mo

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-19 Thread Pavel Stehule
2015-03-19 11:03 GMT+01:00 Tim Uckun : > I guess I see schemas as ways to group data not functions. > > It would be very nice to be able to group your code into proper modules > though. It's something I really miss. > what is advantage modules?

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-19 Thread Thomas Kellerer
Tim Uckun schrieb am 19.03.2015 um 11:03: > I guess I see schemas as ways to group data not functions. A schema is just a namespace. The only "link" between data and a schema is that data can only live in tables and a table is associated with a namespace. Even if you use it to "group data", yo

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-19 Thread Tim Uckun
I guess I see schemas as ways to group data not functions. It would be very nice to be able to group your code into proper modules though. It's something I really miss. >>

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-18 Thread Pavel Stehule
Hi 2015-03-19 2:56 GMT+01:00 Tim Uckun : > What do you guys do to namespace your functions so that they are not > jumbled in with the system functions and also somewhat hierarchically > organized. > > Obviously it's possible to create schemas for different namespaces but > that can lead to a lot

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-18 Thread David G. Johnston
nt: *Wednesday, March 18, 2015 6:56:55 PM > *Subject: *[GENERAL] Name spacing functions and stored procedures > > What do you guys do to namespace your functions so that they are not > jumbled in with the system functions and also somewhat hierarchically > organized. > > Obviousl

Re: [GENERAL] Name spacing functions and stored procedures

2015-03-18 Thread WadeDare4703
I don't understand. What is wrong with having a schema which holds no data? Schemas are cheap. - Original Message - From: "Tim Uckun" To: "pgsql-general" Sent: Wednesday, March 18, 2015 6:56:55 PM Subject: [GENERAL] Name spacing functions and stored proc

[GENERAL] Name spacing functions and stored procedures

2015-03-18 Thread Tim Uckun
What do you guys do to namespace your functions so that they are not jumbled in with the system functions and also somewhat hierarchically organized. Obviously it's possible to create schemas for different namespaces but that can lead to a lot of schemas which hold no data. The other way is to s