podoc:view_random_photo_sql_view
This is an old revision of the document!
Database View Description of "view_random_photo"
Name
view_random_photo
Description
Purpose
Schema
create view view_random_photo as select small_image_path, medium_image_path, large_image_path from photo where photo.identifier=(select cast(random()*count_photos() as integer));
Related tables
Related indexes
Related functions
Related views
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
create view view_random_photo as select small_image_path, medium_image_path, large_image_path from photo where photo.identifier=(select cast(random()*count_photos() as integer));
podoc/view_random_photo_sql_view.1176450950.txt.gz · Last modified: 2007/04/13 07:55 by Luud