Re: CONCAT function equivalent

Ok,

Here's another request, based on my first;

instead of looking for a while to CONCAT my values into said table column,
I tried this:

UPDATE domain SET settings =
('default_language:en_US;default_user_quota:10240;default_groups:;min_passwd_length:0;max_passwd_length:0;disabled_domain_profiles:;disabled_user_profiles:;');

this created 1 line in my column with all the listed values. How can create
those same values in my column but in separate lines, one for each value?
thanks for your help.

- Fabian S.

P.S. sorry about missing the reply all to the list; gmail only shows me the
senders actual address, not the list address so i had to manually re-add
the list address each time i reply i realized. thanks.

On Sat, May 17, 2014 at 12:10 PM, Joe Conway <mail(at)joeconway(dot)com> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 05/17/2014 08:43 AM, Fabian Santiago wrote:
> > will your example literally take care of this task? i assume yours
> > is only an example because you used 'foo' in there and I'm not sure
> > where that comes into play. Excuse my naivety...I don't know
> > postgresql too well (or at all) but need to use it for one server
> > of mine. Thanks.
>
> You didn't post the definition of the table "domain" nor any sample
> data, so the best I could do was a contrived example. When posting to
> the lists it is best to post *complete* information in a form that can
> be easily cut-and-pasted into a terminal to duplicate your problem.
>
> When you do this you make it easy for people to help you, therefore
> you are more likely to get an answer, and the ones you do get will be
> a more accurate reflection of your actual problem.
>
> Also, please keep replies on the list so others can learn from the
> conversation later.
>
> Joe
>
> - --
> Joe Conway
> credativ LLC: http://www.credativ.us
> Linux, PostgreSQL, and general Open Source
> Training, Service, Consulting, & 24x7 Support
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.14 (GNU/Linux)
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQIcBAEBAgAGBQJTd4oEAAoJEDfy90M199hlIzwP/1RDogj62BypJyDuFp0oBlZZ
> blic6vQlj8SBOz9b3cZ9DYqPE4Ue/sOaT5++hcJARLXBgT8MXq6I6VpcdWHindTs
> j35be12MSukWO0ClDtwaYMG8syVph56LyPHdsz9QDql3T6GpNVz0vWreP7t9Y1oj
> /psdYPSFyLfuvqGONhYVqNY8/K1866TF0crGuaYu43I5mdpHBxkZLhxZFw3pXX1O
> ceShZaCz4x85beRwcZRUqpw5dqPwq8omeskFypRzOOG76GJohPikdYK9TM84xAUw
> j00SCNStJsp9+TljtCtPP6sSnt+v0X6Kc/yF1z/AP7muKXRVkt+21iY6joP++muf
> 8Y2LdbdVSNDIBDu3sui68dooOA8InmPmqzwXBcyqK6QrMJ8RMogsAFQvIvlMTNhZ
> Wzr3S2hLznSzPEjo6tYcXvtr45/wjMga/KtyleSpTSI8rACY9bI42F6XtBk4lC9v
> iJwfyhNuB0h0jdvSqdbmB/7f1On5zfMbRSp+hUtSAW727nwNZUX2uN6BYdCiDOh7
> vzsycr2GYHc3SaK/teCI/MEjw11LjRxpMYDZPG/AtWuPL4egsUOZ9BlRHWuj4/if
> LkmUZKbEl3VLNzrGWqjAdAGJrfDmQQaTGiCdMKdfiAVlPITE+uYvZ89coJ2G4sMK
> AEtKoqMayFqychfNPc9z
> =CTkC
> -----END PGP SIGNATURE-----
>

--
Sincerely,

Fabian S.
862-432-2373