( sibidiba | 2009. 04. 19., v – 14:01 )

SELECT user, user || '_dir' AS dir FROM users WHERE user = 'john'

De erre valók a nézetek:

CREATE VIEW userDirs AS SELECT user, user || '_dir' AS dir FROM users

SELECT * FROM userDirs WHERE user = 'john'

--
The Net is indeed vast and infinite...
http://gablog.eu