Re: [SQL] function array_to_string(text[]) does not exist

2013-08-25 Thread Jov
Yes,array_to_string(text[]) does not exist. This from the doc may help: array_to_string(anyarray,text [, text]) text concatenates array elements using supplied delimiter and optional null stringarray_to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*') 1,2,3,*,5 Jov blog: http:

Re: [SQL] How to right justify text in psql?

2013-05-17 Thread Jov
the column type info can be found in information_schema.column view. jov 在 2013-5-17 下午11:27,"Brian Sherwood" 写道: > I am running postgresql 9.2. > > I am assuming it would be a function of psql to right justify text, but I > can't find any way to do this. > > Is

Re: [SQL] How to limit access only to certain records?

2012-06-22 Thread Jov
no,I think there is no such way. what about create view for the user you want to limit,and revoke select privilege from the base table ? 2012/6/22 Andreas > Hi, > > is there a way to limit access for some users only to certain records? > > e.g. there is a customer table and there are account-ma